2003 - Table Merge (Tex Box) Issues...

  • Thread starter Thread starter Doc
  • Start date Start date
D

Doc

Hi,
NOT sure this is the right forum, please direct if such is the case.

Access 2003 with a 'text box' populated by a field that lists names and
address (separate text box for each part of such; name, street, city,
state, zip AND *sometimes* the country [ that is one issue].

We use a preprinted "letter form" to print this data onto and then mail
it out.

We have the name/address fields (text boxes) at both the top and the
bottome of our "report" and then the Address contains a COUNTRY (we do
TRIM if it is the USA) then the WHOLE set of 'text boxes' and any
content gets MOVED down ONE whole line and the "lower address" set of
boxes is no longer readable in the 'envelope window'.

What I want to do is LOCK the subsequent 'text boxes' from moving NO
MATTER if ONE MORE text box (representing the Country) is ADDED at the
top of the report.

Can anyone help me with this? Thanks very much.

Doc
 
Doc said:
NOT sure this is the right forum, please direct if such is the case.

Access 2003 with a 'text box' populated by a field that lists names and
address (separate text box for each part of such; name, street, city,
state, zip AND *sometimes* the country [ that is one issue].

We use a preprinted "letter form" to print this data onto and then mail
it out.

We have the name/address fields (text boxes) at both the top and the
bottome of our "report" and then the Address contains a COUNTRY (we do
TRIM if it is the USA) then the WHOLE set of 'text boxes' and any
content gets MOVED down ONE whole line and the "lower address" set of
boxes is no longer readable in the 'envelope window'.

What I want to do is LOCK the subsequent 'text boxes' from moving NO
MATTER if ONE MORE text box (representing the Country) is ADDED at the
top of the report.
Click to expand...


Make sure that the country text box's CanGrow and CanShrink
properties are set to NO.
 
Marshall Barton typed this:
Doc wrote:
NOT sure this is the right forum, please direct if such is the case.

Access 2003 with a 'text box' populated by a field that lists names and
address (separate text box for each part of such; name, street, city,
state, zip AND *sometimes* the country [ that is one issue].

We use a preprinted "letter form" to print this data onto and then mail
it out.
We have the name/address fields (text boxes) at both the top and the
bottome of our "report" and then the Address contains a COUNTRY (we do
TRIM if it is the USA) then the WHOLE set of 'text boxes' and any
content gets MOVED down ONE whole line and the "lower address" set of
boxes is no longer readable in the 'envelope window'.
What I want to do is LOCK the subsequent 'text boxes' from moving NO
MATTER if ONE MORE text box (representing the Country) is ADDED at the
top of the report.
Click to expand...

Make sure that the country text box's CanGrow and CanShrink
properties are set to NO.
Click to expand...


They already are. The issue is that the "addition" of the 'added' text
box PUSHES the next set of TEXT boxes down and then those push the last
set (which contains the 'envelope' address view) down and out of the
viewing box in the envelope. I want to lock (at least) that LAST set of
'text boxes' so they CANNOT be moved from where I have them in 'design
view'. I hope that I'm presenting this correctly. Thanks.
 
Doc said:
Marshall Barton typed this:
Doc wrote:
NOT sure this is the right forum, please direct if such is the case.

Access 2003 with a 'text box' populated by a field that lists names and
address (separate text box for each part of such; name, street, city,
state, zip AND *sometimes* the country [ that is one issue].

We use a preprinted "letter form" to print this data onto and then mail
it out.
We have the name/address fields (text boxes) at both the top and the
bottome of our "report" and then the Address contains a COUNTRY (we do
TRIM if it is the USA) then the WHOLE set of 'text boxes' and any
content gets MOVED down ONE whole line and the "lower address" set of
boxes is no longer readable in the 'envelope window'.
What I want to do is LOCK the subsequent 'text boxes' from moving NO
MATTER if ONE MORE text box (representing the Country) is ADDED at the
top of the report.
Click to expand...

Make sure that the country text box's CanGrow and CanShrink
properties are set to NO.
Click to expand...


They already are. The issue is that the "addition" of the 'added' text
box PUSHES the next set of TEXT boxes down and then those push the last
set (which contains the 'envelope' address view) down and out of the
viewing box in the envelope. I want to lock (at least) that LAST set of
'text boxes' so they CANNOT be moved from where I have them in 'design
view'. I hope that I'm presenting this correctly. Thanks.
Click to expand...


I guess I don't understand what you mean by "addition" if
it's not CanGrow. Maybe the issue is that you have the
detail section's CanGrow set to Yes, if so change that to No
too.
 
Back
Top