I have text field in form (Reference No)
data entries like this.

Referecne No
----------------
2.1A-101
2.1A-102
2.1A-103
2.1A-....
....

2.1A- is constant value during data entries.
How can make pre-fix 2.1A- in the form field during
data entries, no need to enter 2.1A-

user only enter last digits i.e. 101, 102, 103,.....
it save full record in table i.e.
2.1A-101,
2.1A-102
2.1A-103...
...

What properties will change in form filed ?

Thanks and regards
Mateen

open table in design mode
click on field you want to change
in below pane you wil find input mask
paste following line into input mask
"21.A-"CCCCCCCCCCCCCCCCCCCCCCCCCC...

repeat C for you n-5 time where n is lenght of you field



urt

Help yourself by helping someone.

Thanks for response.

I paste your code in field property,
it only save the records last digit
it not recording, 21.A-

is should be records the pre-fix value also ?
it should records in the table like this.

2.1A-101
2.1A-102
2.1A-103
....
so on

input mast also save the pre-fix value in the table how ?

Thanks
Mateen

Subsequent display issues aside, you could give the user an unbound form field for them to enter 101, 102, etc. Then on the Before Insert and Before Update events of the form, add this code:

Dim sString As String

sString = "2.1A-" & Me.unboundTextFieldName

Me.ReferenceNo = sString

This will save the string the user enters, plus your additional characters when they create a new record or update an existing record. Make sure the ReferenceNo field is set to Visible = No so the user doesn't try to enter data into it.

Did this help?

mmcdonal

Look it up at: http://wrox.books24x7.com

There are other ways to deal with this.

You could set the default value of that field to "2.1A-" and then place the cursor in the position after the hyphen on the textbox's GOT FOCUS event.

You could just set the field to all numbers and place the "2.1A-" in the label in front of the text box. The user ONLY types in the numbers and never the text part. The text part just goes along for the ride in as part of the label in reports, etc.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks you very much.
it is more easy to give default value to that field to "2.1A-".
it is saving the default value with the current data entry records..

I was also try to use before insert and before update event with above code.
but it was not saving the require value.

Thanks and regards
Mateen