If is Null Tne Value equals Zero

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

I have a control on my form that is a counter.
I would like for it to not show (AutoNumber) unless the record has been
saved..
I tried the below, but it did not work.
The control name is Register.

=Nz([Register],0)
 
just off the top of my head, you might like to try conditional formatting to
change the font colour to white (or what ever the background colour of the
cell is) unless the number is >1 ... haven't tested it so i'ld be interested
to hear if it worked.

Cheers
JulieD
 
Just a comment that an AutoNumber is usually a bad choice for a counter,
since there's no guarantee that there won't be gaps.

Realistically, an AutoNumber is intended for one thing only: to provide a
(practically guaranteed) unique value that can be used for a primary key.
Rarely, if ever, should the user even be aware of its value.
 
Back
Top