input mask-cnc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a drawing number field where i would like the number to have the
letters CNC- preceding every number. i would like to have the CNC- show on my
field block prior to me entering the number
thanks, Tony
 
You could use the OnFocus event of the field:

If Me.NewRecord And Nz(Me.MyField, "") = "" Then
Me.MyField = "CNC-"
End If

Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add data from cells based on different criterias? 2
Retieve last dates in a query 2
Intel HD Graphics 4000 Performance 12
Fun Open Source Hardware Projects 9
extract the first line in a text file to use in renaming the file. 3
checkboxes and iif statements 3
Project : Retail Pharma Database 0
Problem with networking 1

Back
Top