Help with setting Input Mask/ Format on Field

[smoker1]

Hello all! I haven't been working with Access 2000 much lately, and have forgotten some of my old "tricks".

I am designing a contact management DB which needs to have the an automatic contact id. I want the id to have the following format:

current year - integer
(ex: 2002-1)

I can't figure out how to get the input mask to accept this format.

Can anyone assist? Thanks in advance.

Angela

 

[mp9]

Try an input mask of

>0000\-00;0;_

All you have to do then is write a bit of VBA to determine the correct next value and populate your field.

HTH

http://www22.brinkster.com/accessory/

 

[smoker1]

Actually, I want the year to be constant. So the first record would be contact 2002-1. The second, 2002-2. The hundredth, 2002-100.....

Any help?

 

[mp9]

Using this input mask on a field called JobNo in a table called tblRequest, I have this bit of code on the OnCurrent event of the form I use for data entry.

If Me.NewRecord = True Then
    If IsNull(DMax("JobNo", "tblRequest", "Year=" & Year())) Then
        JobNo = 100 + Right(Year(), 2)
    Else
        JobNo = 100 + DMax("JobNo", "tblRequest", "Year=" & Year())
    End If
End If

http://www22.brinkster.com/accessory/