Solved: Current Timestamp "Now" funtion format change

I use the "now" function in a textbox to get the timestamp of the systems time but its very basic time and date.

for example [VBA]TextBox1 = Now[/VBA]

I get the following result "04/12/2008 13:11:42"

Is there a way to change the format to say "04/DEC/2008 1.11PM" or "04/DEC/2008 13:11" without the seconds showing?

For military time:
[VBA]Format(Date,"mm/dd/yyyy") & " " & Format(Time,"h.Nn")[/VBA]

[vba]

TextBox1.Text = Format(Now, "dd/mmm/yyyy h:mm AM/PM")
[/vba]

cheers xld! just what i needed, nice and simple coding!