Date field formatting 1

[ray00]

How can I set the text box in a form to show the current date and time in yyyymmdd format? I tried to do it with the input mask but no luck! Any help would be appreciated!

Thanks

 

[MattSmithProg]

Try using this code

txtBox.Value = Format(txtBox.Value, "yyyymmdd&quot No two nulls are the same

 

[SkipVought]

Hi,

Try using something like this - - youwill have to accomodate leading zeroes if you need them

TextBox1.Value = Year(Date) & Month(Date) & Day(Date)

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[ray00]

Thanks Skip! Appreciate your prompt reply. It worked.