wrek
07-10-2001, 12:03 PM
I have a field on my form where I have to be able to accept data like "P " (P Space), however access chops off the trailing space?
any way around this?
any way around this?
|
View Full Version : Accept a " "(SPACE) as data? wrek 07-10-2001, 12:03 PM I have a field on my form where I have to be able to accept data like "P " (P Space), however access chops off the trailing space? any way around this? D-Fresh 07-10-2001, 04:58 PM Well, you could use the format statement... Something like this in the AfterUpdate event of the field... Me!YourField = Format(Me!YourField, "!&&&&&&&&@") The bang(!) causes left to right place filling, the ampersand(&) causes a character to be displayed or nothing, and the At(@) will serve as a placeholder, either a character or a space... This is sorta sloppy, but should work... You should add as many &'s for as long as you think the field would be... If you need more spaces, add more @'s... Hope this could help you out.. Doug |