Input masks

[brothertse2008]

ive set up my database and now that it seems to be working correctly, i want to give it input masks. Ive put in the masks but for some reason they dont implement when running the program.

I used the following masks

ASSET TABLE

Asset tag number
0000000 – Auto number
Asset make
!>L<
Asset model
!>L<
Pc name
!>L<LLL0\_0
Pc serial number
!AAAAAAAAAA


STAFF TABLE

Staff Id number
000 – Auto number
First name
!>L<
Surname
!>L<
Address line 1
!>L<
Address line 2
!>L<
Home telephone
!\(00009\)000000
Email
!>L<


FAULT REF TABLE

Asset tag
0000000
Staff Id number
!000
Date submitted
=now()
Contact
!\(00009\)000000
Fault description
!>L<
Resolution details
!>L<

 

[ajetrumpet]

what's your question?

have you looked at the input mask instruction sheet in the help menu?

 

[DCrake]

Where are you applying the input masks?

Where are you collecting the data?

If you apply input masks to the table structure and collect the data via a form you will need to apply the input mask to the controls on the form for them it be applied to the table.

David

 

[brothertse2008]

oh I see. At the minute they are only applied in the tables. So I just need to open the property dialog box for the controls on the forms and enter the masks.

Thanks, il give that a try