Input Masking a Text box

G

Guest

Hi,

I've got a form with a few text boxes which are used to collect dates and
was wondering if anyone knew of an easy way to make the text boxes only take
a date format, kinda like the Input Mask function you can use in Access.

Any ideas anyone?

Ta.

Neily
 
T

Tom Ogilvy

You can use the afterupdate or exit events to examine the input and react to
it. The change event or one of the key events could be used to examine the
entry in progress.

The is no built in mask function/setting or validation function/setting.
 

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

Validation on text input boxes on a form 11
Force proper case on user form text box 7
Input Masking 1
assigning text box input to a sheet 1
User form Text Box & Combo Box. 5
text box input data concatenate to file name 1
Excel 97, text box Input Mask, local date format 3
Building a String based on Selected Check boxes 4

Top