I am creating an input mask for Tax file numbers which take the format:
333-444-555
When I build the input mask as 000-000-000, access converts this to 000\-000\-000;0;_
Can anyone tell me what the semi colon and separate zero are for.
Thanks
Shirley
3  1033 
Hi Shirley,
Welcome to the Scripts!
You've posted your question unintentionally in our Articles section. I will move it across for you to the main forum where it is much more likely to be viewed!
MODERATOR
This is a reply to a similar thread, the reply is by one of our experts, JConsulting :
Input masks contain three sections, all separated by semicolons. The first section is mandatory, and the rest are optional. The first section defines the mask string and consists of placeholder and literal characters. The second section defines whether you want to store the mask characters plus the data in the field. Enter 0 if you want to store the mask and your data; enter 1 if you only want to store the data. The third section defines the placeholder used to indicate a position for data. By default, Access uses the underscore (_). If you want to use another character, you can enter it in the desired position in the mask string, or you can enter it in the third section of your mask. Also, by default, a position in an input mask accepts only one character or space.
For example, this input mask forces users to enter dates in a format used in many parts of the world.
00 LLL 0000;0;_
The first section defines the mask. In this case, the zero acts as a placeholder for digits, and L acts as a placeholder for letters. The mask requires a pair of numbers for the day of the month (the first two zeroes) and all four digits of the year (the last four zeroes). The three instances of L require a three-letter abbreviation for the month.
The second section forces Access to store the mask characters along with the data. The third section specifies the underscore as the placeholder character. If you want, you can also add a date separator to the mask string, like so: 00/LLL/0000;0;_.
Kind regards,
Scott
For more information have a look at this article: Input Masks
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics
by: dude |
last post by:
hello
how would i make an input mask that only makes the first letter a
capitol one?
i've been playing around and testing various masks, also tried the
wizard, but i've had no luck.
could...
|
by: Mark Lees |
last post by:
I want to create an input mask for a phone number and I would like the
area code to always be (801). However, I want the users to be able to
edit it if necessary.
Would it look like this =...
|
by: David W. Fenton |
last post by:
I'm working on a subform where users put in 24-hour time. On their
paper forms, they've been accustomed to referring to midnight as
24:00 (instead of as 0:00, which kind of makes sense from a human...
|
by: F. Michael Miller |
last post by:
I have a db with Access front end, sql back, linked tables. I need to be
able to change input masks at the table level in code.
Any ideas?
Thanks!
|
by: Regnab |
last post by:
Morning All,
I'm trying to ensure that when the user enters a number on a form, the
database automatically leaves a space after the 3rd number. I've tried
to do this using input masks, but when...
|
by: BerkshireGuy |
last post by:
Is there a way to display what the expected format is before entering a
control.
For instance, if I have the input mask of 99/99/0000;0;#, it shows me
##/##/##, but only when I type the first...
|
by: Filips Benoit |
last post by:
Dear all,
I have a datefield that sometimes should store hours and minutes too ans use
following format and inputmask.
dd/mm/yyyy hh\:nn
09/09/0000\ 99:99;0;*
Typing date, hour and...
|
by: Dave |
last post by:
Hello -
Say I have a 32 bit value in data (v:4, r:4, l:8, p:16)
unsigned char data;
Now, for portabilities sake, I want to use shifts and masks to access
these fields, instead of accessing...
|
by: panjap |
last post by:
a few days a go i was kindly helped with the trouble i was having on editing lables wjhere i wanted to change access' messages to my own.
Below si the qeustion i set a few days agoa , which worked...
|
by: ezechiel |
last post by:
hi everyone..
i read on another forum that it is possible to define multiple input masks for a textbox (for example).
There is a textbox field where you can enter the name of a machine.
The...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
