PO number using date/Time

T

T.K.

I am tring to create a PO number such as R-010205153024
(month,day,year,time-militray time,second).. for each added entry into a text
box associated to a table, How do I do this?
 
M

Marshall Barton

T.K. said:
I am tring to create a PO number such as R-010205153024
(month,day,year,time-militray time,second).. for each added entry into a text
box associated to a table, How do I do this?
Click to expand...


Make the Field in the table a Text type field. Set the
DefaultValue property of the text box on the form to:

"R-" & Format(Now(),"mmddyyhhnnss")
 
Top