Dynamic Input Mask

G

Guest

We have need for 2 input mask. Would like user to select from 2 types of
input in the form, so the criteria would be a text field with 1 character in
size. For example, 1 mask would be __-_-__-_ and the other ___-_-__-__.
 
T

tina

in a form, you can set a control's InputMask property at runtime, using a
macro or VBA. if the user is selecting "from 2 types of input", presumably
in a combo box, list box, or option group, in the form, then you can use
that control's AfterUpdate event to run a macro or VBA procedure to set the
InputMask property of another control in the form. see the InputMask
Property topic in Access Help for details, and post back if you run into
problems.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Mask Help 1
Date Input Mask Question 4
Creating Custom MS-Access Input Masks 0
Telephone number Input mask displaying in form control 2
Using input mask, filter by form 9
Input Mask for General Date/Time 1
Input Mask - quick question 6
Cursor move from the beginning of text field 1

Top