Input Mask in Text Box on form 2

[errolf]

I am using a text box on form to input records to a table. I need to to prefix each record in the table with the letters CPFE. The Input Mask that I am using a present is "CPFE"&&&&&&. This shows correctly in the text box but only the numbers are transferred to the table and not the CPFE prefix. What do I need to do to overcome this situation
In anticipation

Errol Featherstone

 

[Onyxpurr]

Have you tried setting the default to "CPFE" as well?

 

[errolf]

Thanks for the suggestion, I have tried this but it does not make any difference I still only get the numbers inputted but no prefix.
Thanks again

Errol

 

[Onyxpurr]

I would do a check in VBA after update on that text box. Something like...

If left(me.textbox,4) <> "CPFE" Then
me.textbox = "CPFE" & me.textbox
End If

 

[PHV]

Have you tried this ?
"CPFE"&&&&&&[highlight];0[/highlight]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[errolf]

Thanks For your help adding the semi colon and the zero solved the problem.
Thanks
Errol Featherstone