date

[mary555]

How do I get a textbox to work so that if a user enters a time (short time with input mask) that the current date will automatically be with it. If the time the user enters is after midnight, then the date with it should be correct day as well...

 

[dhookom]

I'm not sure exactly what you want. I expect that you could use the after update event of the text box to add the date to the text box value:

   Me.txtMyTextBox = Date() + TimeValue(Me.txtMyTextBox)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lupins46]

In the afterupdate event of the textbox control put:

me.textboxname= date() + timevalue(me.textboxname)

 

[mary555]

thanks, that works.
now i just need it so that if the time they enter is after midnight but the current time is before midnight, then the date will be date + 1...is there an easy way to do this without a huge if statement?

 

[lupins46]

You will have to define some limits.

Every time is both 'before midnight' AND 'after midnight'