I have a Maintenance database that tracks downtime and maintenance records on machines on the factory floor. I have two fields named TimeDown and TimeBackUp. The Format in the properties is set at h:nn am/pm dd-mmm-yy. The Default value is set at =Now(). When you go to edit the record, sometimes it stays at the format h:nn am/pm dd-mmm-yy so that the hours and minutes show first and you can edit it that way, and sometimes it reverts back to the General Date format, which makes the user have to edit at a different spot. It also does not handle the two formats consistently in my reports. I know I fixed a similar problem for date by having the Default value be =Date(). When I tried =Time() it worked except the date turned out to be December 30, 1899, not the date the machine went down. Does someone know a way to format the field consistently? Thanks
------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hdf3gme/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123707188/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
