Report Addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an addr1 and addr2 field. When the addr2 field is blank, it is
leaving an unnecessary space before the city and state. Is there a way to
tell access that if the field is blank to ignor so that no extra space is
appearing?
 
I have an addr1 and addr2 field. When the addr2 field is blank, it is
leaving an unnecessary space before the city and state. Is there a way to
tell access that if the field is blank to ignor so that no extra space is
appearing?
Click to expand...

One way is to set the [Addr2] control's CanShrink property to Yes.
If there is no other control on that same line, the next line will
move up.
 
Back
Top