Display HHMMSS in Access 2013

[didiomm]

Hi all:

I have a database that pulls in a table from excel 2013. On my Access form, one of the text boxes with information that I display needs to be in hhmmss format ("custom" formatting in excel). Instead, it displays on my form as ######. What do I need to change, set, etc to get the hhmmss format?

Please let me know what I need to clarify.

Thank you for any help!

[AlexHedley]

Have you tried extending the box to fit the data?

You can use the Format property to set custom formats.

[didiomm]

Thanks for your reply! I think it was a combination of the format setting and the length of the
text box. I manipulated both and this morning extended my text box "one last time" and it seems
to display. However the HHMMSS is in time format i.e. 12:04 am. I need it to display 00:04:16.
Working this out now.

[AlexHedley]

Add the ":" between HHMMSS => HH:MM:SS