Thread: Input Mask Help
View Single Post
  #2  
Old April 27th, 2004, 04:03 AM
DDM
external usenet poster
 
Posts: n/a
Default Input Mask Help

DD, this will do it: &&&&&"ACC";;_ (put at the beginning if you want caps
throughout).

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

"DD" wrote in message
...
Hello kind and helpful people. I have a field in a table
for which the syntax is 8 characters (both alpha and
numeric). The last 3 digits of these 8 characters will be
capital ACC. Examples: 12345ACC or A4B3CACC. I need help
with the input mask. I would think the beginning part of
the mask would be &&&&& (5 digits or characters required)
but then I do not know how to force the ACC in all caps
immediately after these 5 characters and make them appear
so that the user is not required to enter them. Thanks in
advance.