ms-accessinput-mask
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
- Looking to get a string evaluated a second time so that I can change a single rule across independent queries
- SQL Server migrate new data into old schema
- Copy a ODBC-linked SQL-Table to an Access table with VBA
- Creating a Document Database using Microsoft Access
- Import CSV file and transpose to tabular table
- In MS Access using VBA: I want to transfer records with less than N^2 time complexity
- Microsoft Access SQL
- SqlCommand doesn't return result from the C# application (MS Access database)
- Access 2010 Forms VBA - Set Focus to Record on image click
- Expressing basic Access query criteria as regular expressions
- Where is acedao.dll?
- How to show the same field value from another entity attributes
- Convert Foxpro .dbf file to excel via ms access
- Opening table shows "Enter parameter value"
- Init Date variable with null value
- Button To Add Text and a new line
- Ms Access series numbering that resets monthly and yearly
- Recordset.Sort method not sorting
- How can I remove a link to an excel document from a previous 'DoCmd.TransferSpreadsheet acLink ..' command?
- MS Access Edge Browser Control to call a telephone number (W10)
- Creating a relationship with a calculated field
- how to count the number of records with ExecuteScalar if more than one then cannot insert into in the MS Access database on vb.net
- How to list DataMacro objects in an Access database?
- Inner join returning duplicate records access sql
- The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data
- How can I always round up decimal values to the nearest integer value?
- Word VBA insert multiple images and captions at bookmarked location in template document from Access
- Conversion from string to Date with PM is not valid in VB.Net
- Access change dates on other date fields based on date in first date field
- How do I force MS Access to retain its SQL formatting?