This expression assumes that CustomerID is a text string. The value of CustomerID is enclosed in single quotes.
ID is not a row number. It is the name of a field. If that field is an AutoNumber field, its value is guaranteed to be unique. It is usually populated by a sequence number that starts at 1 and increases by 1 for each new record, but it is not guaranteed to be the row number. If a record is deleted, there will be a gap in the sequence. And when you start creating a new record, a new AutoNumber value is assigned, but if you then cancel the new record by pressing Esc twice, that AutoNumber value will not be reused, so that also leaves a gap in the sequence. So you could have a series of values like
1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 13, 16, 17, 18, ...
Conditional Formatting for an ID>1
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting for an ID>1
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Conditional Formatting for an ID>1
Thanks for the response.
Bit
Bit