How to format a "Number" Data type

[undee69]

Hi everyone,



I am trying to format my Number data type to look like this: 0001 / 2013 where "0000" is the prefix, 1 is the number and " / 2013" is the suffix.

Tablename: tblclients
Field Name: DelNoteNo
Data type: Number

Form
Control Name: DelNoteNo
Control Source: DelNoteNo

I am searching on this forum but I can't get it working.

On the Before Up date procedure i have:

DelNoteNo = Nz(DMax(DelNoteNo, "tblClients"), 0) +1

but its is giving "invalid use of Null "

What am I missing?

[pbaldy]

The field name needs to be in quotes in the DMax.

[undee69]

I am using the code below

Private Sub DelNoteNo_BeforeUpdate(Cancel As Integer)

DelNoteNo = Nz(DMax("DelNoteNo", "tblClients"), 0) + 1

End Sub

but when I try to enter 1 or any number, it gives me the error :

Run-time error '-2147352567 (80020009):

The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field.

[undee69]

What I want it to achieve is for it to show the following series as my "DelNoteNo"

0001
0002
0003
.
.
.
0010
0011
.
.
.
0100

is this possible?

[undee69]

I solved it myself ^_^

DelNoteNo Table Properties
Format: \000" / 2013"

DelNoteNo Control Properties
Format: \000" / 2013"
Default Value: =Nz(DMax("DelNoteNo","tblClients"),0)+1