Input Mask for Street Address

[Don Garry]

Hello...
I have a form which is has a street address on it and would like it to look
consistent with an input mask. One user likes to have his cap locks on and
the other user likes to use lower case.

I'd sure a appreciate it if someone could let me know what the input mask
would be for a street address like the following regardless if the user was
using upper or lower case:
604-1234 Somewhere Rd.

 

[Reggie]

Don, Not sure of an input mask for this, but if you place a grater then (>) sign in the Format
property of the field in you table/report/forms etc. the user can type any way they want and once
they move out of the field it will always be displayed in upper case letters. That would be
consistent!

Hope it helps!

 

[fredg]

Hello...
I have a form which is has a street address on it and would like it to look
consistent with an input mask. One user likes to have his cap locks on and
the other user likes to use lower case.

I'd sure a appreciate it if someone could let me know what the input mask
would be for a street address like the following regardless if the user was
using upper or lower case:
604-1234 Somewhere Rd.

No mask will do this.
Code the Address control's AfterUpdate event:
Me![AddressControl] = StrConv(Me![AddressControl],3)

All entries regardless of how entered will have capital first letter
for each name in the field. Note: This may have unintended results.
A correct entry of 123 So. van Houten Street
will become 123 So. Van Houten Street, etc.
and 567 MacGregor Lane becomes 567 Macgregor Lane.

If capitalization accuracy is important, you will need a table of
exceptions and compare each entry to the table. This can be done
programmatically.
Even then, some cities may capitalize the same name differently.