how to remove ":", "." from a box - field (1 Viewer)

[felipe_gg]

Hello Everyone!

hope u guys can lend me a hand pls!

i'm trying to make a form to report problems affecting our production machines.
by default my company has always used the term OT. to make such reports (its date and time (time without seconds) example: "150320211655")
the problem is that im not able to make that OT without dots and ":", i'm getting 15.03.2021:16:50
im suuuper newb to access so im trying my best to avoid VBA
what i currently have in the table is 3 fields with date, time and a calculated one with date&time... i managed to put them together, yay...
now im stuck, and cant get it to work
i dont even know if its a good idea at this point lol

thanks in advance

 

[The_Doc_Man]

You can format a date/time field like this:

Format( my-date-field, "ddmmyyyyhhnn" )

 

[felipe_gg]

hoooly ..
that was fast.. and it worked!!
thanks man
what a relief ! theres so much to learn

 

[The_Doc_Man]

No problem, always happy to help.

Come back when you've got more questions. One of us will get back to you. I keep an odd schedule but we have a large number of folks who pitch in from various time zones.