Conditional Formatting for an ID>1

User avatar
HansV
Administrator
Posts: 78608
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Formatting for an ID>1

Post by HansV »

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, ...
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Conditional Formatting for an ID>1

Post by BittenApple »

Thanks for the response.
Bit