Format Value

J

jovenlibre

hy, i make a DB, that record student information, the field of student number
was need to be one format and start with CU fallow set of number. for example
CU123456. how to make a value that only enter the number, then access create
the standard CU? thanks
 
K

KARL DEWEY

Open the table in design view, click on the field, in the InputMask type --
"CU"#
You just enter the number and it adds the 'CU' in front for display. If
you need to use criteria on the field you will have to omit the 'CU' and just
enter the number.
OR
Enter CU in the Default and it will automatically enter 'CU' into each new
record and you can add the number portion behind.
 
J

jovenlibre via AccessMonster.com

Thanks for you replay
When i add "CU"# in the InputMask, in the entry, does not leave to entrer a
number, i write CU in the defualt value, but when i going to the entry the CU
going.
i set the table:
FieldSize:10
Format: #
thanks.
 
K

KARL DEWEY

Why not just use number in the field and then in query for forms and reports
use a calculated field like this --
Student Number: "CU" & [NumberField]
 
Top