PO number using date/Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
Back
Top