Access - date and time in textbox?

[Lee_S]

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

[salvelinus]

Why not just concatenate two variables in one textbox? Or look at the Format functions.

[Lee_S]

Yeah just realised i could use the format function on the textbox
dddd", "d mmm yyyy", "hh:nn AM/PM works