Need a proper input mask for a time field in Microsoft Access
My table field is date/time and formatted like this:
mm/dd/yyyy hh:nn:ss
I want the user to see this (with the space appearing between date and time
__/__/__ __:__:__
I want an input mask that demands:
- Either 1 or 2 digits for the month
- Either 1 or 2 digits for the dat
- All 4 digits for the year
- SHOWS the space but just jumps over it for the user
- Either 1 or 2 digits for each of Hours, Minutes and Seconds
Further, when setting up a DB, is it just smarter to have two separate fields for Date and Time. A collegue encouraged me to break them out ... seems sensible?
Solution
00/00/0000##00:00:00
See the outcome in the image
- Running asynchronous query in MS Access
- Updating Linked Table not Supported in this ISAM
- SQL Server returns different record after insert on linked MS Access table
- Select only positive values between 2 dates as a calculated column
- How to have the result of a query in a textbox?
- Find secondary email account to use SendUsingAccount property
- Access VBA code generates separate email for each recipient; need to generate single email for each client with multiple recipients
- MS Access 365 Filtering between two dates using Embedded Macros
- Difference between ADO and DAO
- select column name with special character (ó)
- How to get the Sid as a String of a Token group in C#?
- Calculating MD5 of string from Microsoft Access
- MS Access VBA code
- SQL Alternative to For Loop
- Insert a new record into an Access 2007 database
- Pass a MS Access form date to Oracle via a Pass-Through Query
- Access splitform how to move the caret (or set the focus) from the sheet section to the form section and viceversa
- Access VBA - adding row with multiple columns
- Convert Access Database to SQL Microsoft DTS - Data Type '130' not in mapping file
- Press enter in textbox and execute button function in VBA
- How do you comment an MS-access Query?
- DoCmd.RunCommand commando buttons in MS Access splitform imitating filter buttons in ribbon
- Is there a way to 'normalise' my data as it currently is?
- Mod with Doubles
- Calculating Year-to-date income and expense
- How to format autonumbered value in calculated field in Access
- Adding Trusted Location to Access Run Time
- Complex query in MS Access for a history/tracking table?
- How can I make a combo box readonly in Access 2000?
- formatting phone numbers ms access