Dual Input Mask for a field

[BSC5905]

Is there a way to apply a dual “Input Mask” to a field in a table? The data is the location of employee’s cubes and offices. We use two different formats. The Input Mask that I am using are:

>L0-000 - Office location format.
>L0-L000 - Cube location format.

Example:
A2-123
B2-B308

Or could this be done using Visual Basic code?

 

[dhookom]

I expect you could use the On Current event of your form to lookup the appropriate input mask property in a table. Then just set the property.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[traingamer]

Try

L0\-?000

with the ? making the second character optional.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill