Date and time without separators and a suffix to be added at the back

[joym]

On a textbox "date" i use me.txtDate = Now () which displays the current date and time in the format dd/mm/yyyy hh/mm/ss am pm



i would like this to be displayed without separators as ddmmyyhhmmss and a constant suffix
eg todays date is 18/05/17 2:37:12 PM i want it displayed as "180517023712 YES"

is there a way that this can be done

[June7]

So is textbox bound to a date/time field?

[joym]

no it is in shorttext format

[June7]

Okay, try:

Me.txtDate = Format(Now(), "mmddyyhhnnss") & " YES"

But why save data in this format? Why not save a true date value and do formatting on report?

[joym]

Okay, try:

Me.txtDate = Format(Now(), "mmddyyhhnnss") & " YES"

But why save data in this format? Why not save a true date value and do formatting on report?

That worked like a charm

Thou i tried a similar code but the letters did not show
Me.txtDate = now() & " YES"

the reason i was testing this was i am trying to produce a unique codes for ticketing and was testing it out on another test access db

[June7]

That should work also. But it would save the date string with separators.