Access: Input Mask and Inserting Current Date

P

Paul-AZ-TX

I set up a text box that is tied to a field defined as Short Date with an
input mask of 99/99/0000;0;_ To make data entry easier, I have a command
button that inserts the current date into this text box using the Access VB
code: Text164.Text = Date

If I have no input mask the text box's properties, the command button works,
but if I include the input mask it does not insert the date. I have tried
various options on the input mask but it does not work. Since there are many
dates on the form that the user updates, I want the input mask so all dates
are entered consistently. Any ideas?
 

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

Creating a Search using a combo box and then creating a report. 4
Remove input mask format 4
Time format hh:nn drops leading zero 0
Date Input Mask - inconsistent displayed value 1
Access 2003 1
Qry help...Maybe a double post...my apologies in advance... 8
Date Mask auto changes 1916 to 2016 2
Input Mask Help 1

Top