Data Form and Time Format

Jeremy Dillberg

Guest

Posts: n/a

26th Nov 2003

I have formatted times in a spreadsheet with [hh]:mm:ss in
order to add past 24 hours. What I would like to know is
how come when I open a Data Form through a macro, the
information is still shown in with AM or PM or with a date
at the beginning if the total is greater than 24 hours.
Is there a way for me to format this with code. My macro
to open the data form is simple....
Worksheets("Stats").ShowDataForm

Thank you,
Jeremy

« Column headings switched to numbers | Export Macro »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
format of Form field that allows data to be copied without format	=?Utf-8?B?S2VuIEdlaGxl?=	Microsoft Access Forms	6	27th Oct 2006 05:59 PM
StampDate Format For Data and Time	srm	Microsoft Outlook Form Programming	1	8th Jun 2005 05:31 PM
format data displayed on Excel data entry form	=?Utf-8?B?Qm9iLCB0b28=?=	Microsoft Excel Setup	0	19th May 2005 08:26 PM
Display time on form, add current time data	SandyB	Microsoft Access Form Coding	1	26th Feb 2004 07:10 PM
import data time format	Steve	Microsoft Excel Programming	2	28th Sep 2003 03:40 AM