Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retrieving Todays Date? 1
- Thread starter JaeBrett
- Start date
When loading your form, set the content of your textbox to: format$(date, "mm/dd/yyyy"
.
To validate what they've entered, a textbox isn't the best control to use - use something like the datetime picker that prevents the user from entering bad values.
Chip H.
.To validate what they've entered, a textbox isn't the best control to use - use something like the datetime picker that prevents the user from entering bad values.
Chip H.
-
1
- #3
NoCoolHandle
Programmer
To add it you could use
txtDate.text = Format(Date(),"MM/DD/YY"
(I think the syntax for date formatting is correct, but search help on fromat.. -date is a vb function that returns the current system date, but you could also use Now()
to make sure that the date is correct when they leave
2 options
1
sub txtDate_Validate()
if not isdate(txtdate.text) then
msgbox "this is not a valid date"
txtdate.setfocus
end if
end sub
2. Use the maskededit control
txtDate.text = Format(Date(),"MM/DD/YY"
(I think the syntax for date formatting is correct, but search help on fromat.. -date is a vb function that returns the current system date, but you could also use Now()
to make sure that the date is correct when they leave
2 options
1
sub txtDate_Validate()
if not isdate(txtdate.text) then
msgbox "this is not a valid date"
txtdate.setfocus
end if
end sub
2. Use the maskededit control
- Thread starter
- #4
- Status
