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.
 
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

IIF function 9
How to Make Control Value to Null (Leo asked) 2
Replace "assign the null value" message 1
A realtion from one form to the same form? 1
Resetting the counter on AutoNumber 2
Need help to Simplify a Complex Calculation on a Form 0
Zeros Everywhere! 3
Need help on how to pass calculated field from a form to another form 0

Back
Top