Help!

Can Grow moves lower fields

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports RSS
Next:  2 gb limit and linked tables  
Author Message
Chuck
External


Since: Apr 02, 2006
Posts: 24



PostPosted: Mon Oct 26, 2009 3:19 pm    Post subject: Can Grow moves lower fields
Archived from groups: microsoft>public>access>reports (more info?)

Hello, I have a form that starts with the client address at the top. The
address field grows / shrinks for multiple address lines. No problem.
BUT then I have a positional filed that must start 3 inches from the top.
For each extra line in the address teh positional field is moved down a line.
How can I always have this field start in the same position on the page
regardless of how many lines in the address?
Thanks
Chuck
Back to top
KARL DEWEY
External


Since: Mar 03, 2006
Posts: 1616



PostPosted: Mon Oct 26, 2009 3:53 pm    Post subject: RE: Can Grow moves lower fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Then do not let it grow or shrink. Set it to the maximum you will ever need
and it will not interfere with the positional field.

--
Build a little, test a little.


"Chuck" wrote:

> Hello, I have a form that starts with the client address at the top. The
> address field grows / shrinks for multiple address lines. No problem.
> BUT then I have a positional filed that must start 3 inches from the top.
> For each extra line in the address teh positional field is moved down a line.
> How can I always have this field start in the same position on the page
> regardless of how many lines in the address?
> Thanks
> Chuck
Back to top
Chuck
External


Since: Apr 02, 2006
Posts: 24



PostPosted: Tue Oct 27, 2009 1:59 pm    Post subject: RE: Can Grow moves lower fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks however that wouldn't work. The can grow field is the street address
which is follwed by the City, State Zip field. If I make the street field the
size to hold 3 lines then whene there is only one line the City, St Zip will
be seperated and not look right.

"KARL DEWEY" wrote:

> Then do not let it grow or shrink. Set it to the maximum you will ever need
> and it will not interfere with the positional field.
>
> --
> Build a little, test a little.
>
>
> "Chuck" wrote:
>
> > Hello, I have a form that starts with the client address at the top. The
> > address field grows / shrinks for multiple address lines. No problem.
> > BUT then I have a positional filed that must start 3 inches from the top.
> > For each extra line in the address teh positional field is moved down a line.
> > How can I always have this field start in the same position on the page
> > regardless of how many lines in the address?
> > Thanks
> > Chuck
Back to top
KARL DEWEY
External


Since: Mar 03, 2006
Posts: 1616



PostPosted: Tue Oct 27, 2009 2:48 pm    Post subject: RE: Can Grow moves lower fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Concatenat the street address, City, State. and Zip into one field.
WholeAddr: [street address] & Chr(13) & Chr(10) & City & ", " & State & "
" & [Zip]

--
Build a little, test a little.


"Chuck" wrote:

> Thanks however that wouldn't work. The can grow field is the street address
> which is follwed by the City, State Zip field. If I make the street field the
> size to hold 3 lines then whene there is only one line the City, St Zip will
> be seperated and not look right.
>
> "KARL DEWEY" wrote:
>
> > Then do not let it grow or shrink. Set it to the maximum you will ever need
> > and it will not interfere with the positional field.
> >
> > --
> > Build a little, test a little.
> >
> >
> > "Chuck" wrote:
> >
> > > Hello, I have a form that starts with the client address at the top. The
> > > address field grows / shrinks for multiple address lines. No problem.
> > > BUT then I have a positional filed that must start 3 inches from the top.
> > > For each extra line in the address teh positional field is moved down a line.
> > > How can I always have this field start in the same position on the page
> > > regardless of how many lines in the address?
> > > Thanks
> > > Chuck
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum