Now( ) Function

[Guest]

On one of my forms I have a Start Date Textbox and a End Date Textbox. When
the form loads I have it so that the Date is automatically entered in the two
text boxes with the code....

me.txtStartDate = Now
me.txtEndDate = Now

This works however it also puts the time into the textbox as well. I have
the format property of the textbox set to "short date" but it still puts the
time in. Anyway to load the date in a textbox without the time going in as
well?

 

[Rick Brandt]

On one of my forms I have a Start Date Textbox and a End Date Textbox. When
the form loads I have it so that the Date is automatically entered in the two
text boxes with the code....

me.txtStartDate = Now
me.txtEndDate = Now

This works however it also puts the time into the textbox as well. I have
the format property of the textbox set to "short date" but it still puts the
time in. Anyway to load the date in a textbox without the time going in as
well?

Use Date instead of Now.

 

[Guest]

Try the Date function e.g.

me.txtStartDate = Date
me.txtEndDate = me.txtStartDate

Hope This Helps
Gerald Stanley MCSD

 

[Rob Oldfield]

= Date