Input Mask Help

  • Thread starter Thread starter DD
  • Start date Start date
D

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.
 
The last 3 digits of these 8 characters will be
capital ACC. Examples: 12345ACC or A4B3CACC. I need help
with the input mask.
Click to expand...

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
 
Back
Top