Input Mask Help

[DD]

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.

 

[DDM]

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

 

[Tim Ferguson]

The last 3 digits of these 8 characters will be
capital ACC. Examples: 12345ACC or A4B3CACC. I need help
with the input mask.

If the ACC is always going to be ACC, then don't store it at all:- just use
the Format property to stick it on in the text box.

If the ACC might change, and if it means something, then you probably
should be storing it in a separate field anyway, and concatenating them in
the textbox on the report or the form.

HTH


Tim F