Report Addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GeorgeH - 29 Oct 2004 01:17 GMT

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?

Signature

GeorgeH

Reply to this Message

fredg - 29 Oct 2004 03:18 GMT

> 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?

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.

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message