Input Mask in an Input Box

[cukarisol]

Hi all

What I need to do is insert a "Short Date" (dd/mm/yyyy) input mask into an input box that feeds into a date field (with "Short Date Format").

Just wondering whether:
1. This is possible?
2. Are there are any other ways to better control information that gets inserted into an input box (particularly dates)?

Thanks in advance

[HansV]

Hi,

In which application are you using the input box?

[cukarisol]

Hi Hans

Application that I'm using,
Frontend = MS Access 2003
Backend = Sybase

Thanks

[HansV]

The InputBox function does not have an input mask feature.

Instead, I'd use a text box on a form and set its Format property to Short Date or to Medium Date. The will let users enter only valid dates. You can refer to the value of the text box in your code.

Post back with more details if you need additional help.

[cukarisol]

Hi Hans

I believe that you're suggestion is the only viable option here.

I'll make a pop-up form that looks very similar to an input box and get users to enter relevant info here (with relevant input masks present).

Thanks