Missing literal characters in Input Mask

[Aaron]

Hello,

I need a user to enter data in a text field on a form in the following
format; "ABC - 123".

I have coded the input mask using VBA as such,

Me!Standard.InputMask = "LLL\ \-\ 000"

Where 'Standard' is the text field on a form which has a control source
called Standard from a table.

When the user inputs the data in the Standard field, the input mask works as
desired but for some reason the Standard is saved in the table in a different
format. The text is saved in the table as "ABC123" rather than "ABC - 123".
For some reason the " - " is getting cut out. The 'Standard' field in the
table is a text field. I am using MS Access 2003 with SP3 installed.

Thank You for your time and effort in advance,
Aaron

 

[Damon Heron]

Maybe you should have used the wizard to complete the new input mask for
you. The last screen allows you to store the data with or without
formatting.

Damon

 

[Damon Heron]

Oh forgot. Here is the input mask: LLL\-000;0;_

Damon

 

[Aaron]

Thank you very much for the suggestion and it worked,

However, I should have mentioned that it is necessary to create the input
mask through VBA coding because the Input mask is dependent on the value of
other value boxes on the form. I noticed in the wizard that you can display
your inputmask "with the symbols in the mask, like this 'ABC - 123' ".

Is there way to somehow access or use this option using MS Access VBA?

Thanks again for your time and effort,
Aaron

 

[Aaron]

Thanks for your help, but after playing around, having the ;0 finally worked.
For some reason it wouldn't read it before. Thanks!