Access - date and time in textbox?
This is probably simple, but how do i format the date to show date and time in a textbox?
Unbound textbox on form set to =Now()
But I want the format "Monday 30 May, 2005, 12:15 pm" if possible. Basically adding Long Date and Medium Time together.
I could do a seperate textbox for date and time, but then you get a gap between the textboxes, depending on the length of the date. Is there a way to align the time textbox always to be next to the date box?
cheers
lee
Re: Access - date and time in textbox?
Why not just concatenate two variables in one textbox? Or look at the Format functions.
Re: Access - date and time in textbox?
Yeah just realised i could use the format function on the textbox :o
dddd", "d mmm yyyy", "hh:nn AM/PM works