Problem with date and time formatting on reports

[Inky2201]

Hello,
I have a problem with entering the date and time on a report tidily. At present I have 2 text boxes, one for date and one for time with an "at" in another text box in the middle e.g. [26th July 2005] [at] [9.30PM].
When I use this method the first text box has to be large enough to accept December so if the date is May it leaves a large gap and I am trying to find a way over this.
I have tried putting both together in a string e.g.
[Date]&" at "&[Time] which works but then I cannot format the date and time to Long Date and Medium Time.
Is there an easy way over this?
Hope to hear from you avids out there.
regards
I

 

[SkipVought]

Hi,

Use the Format function...

Format([Date],"dd mmm yyyy")&" at "&Format([Time],"hh:nn AM")

Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie![/sub]

 

[RoyVidar]

This is the Access Modules/VBA Coding forum, for report qestions, try the reports forum (forum703)

Another non code suggestion for this report control question, is using =now() as controlsource, then use the format property of the control

[tt]dd mmmm yyyy" at "hh:nn AMPM[/tt]

Roy-Vidar

 

[Inky2201]

Thanks both of you,
I think Skips idea is more appropriate as the date and time will not be todays but a booked date and time for the future.
But both are worthwhile - thanks
I