I have a date/time field that stores the date and time. I would like the time portion of the field to display a little smaller and maybe a different color on the form. Is it possible to format half of the same text box programatically?
Competent Performer
Windows 7 64bit 
Access 2007
I have a date/time field that stores the date and time. I would like the time portion of the field to display a little smaller and maybe a different color on the form. Is it possible to format half of the same text box programatically?
VIP
Windows XP Access 2010 32bit
Very much doubt it. Try Google search.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
User
Windows 7 64bit Access 2010 32bit
For visual purposes you could make two fields.
MyDate Format Date() Short Date
MyTime Format Time() Medium Time
Lay them side by side without borders to get the desired affect.
Make the time field smaller with a different color.
Using the Primary Key as part of another field
Unmatched query to lookup part of the field
Hiding Part Of a Field
Posting Permissions
Reply With Quote