Can I make the form record number equal the record id number?

T

Terry T

There have been some records deleted and this makes the two numbers not
equal. I would prefer they equal. Is there a way to do this?
 
D

Douglas J. Steele

Assuming you're talking about an AutoNujber field, there's no simple way to
renumber the rows.

In general, it's not recommended to try.
 
J

John W. Vinson

On Mon, 24 Sep 2007 10:06:05 -0700, Terry T <Terry
There have been some records deleted and this makes the two numbers not
equal. I would prefer they equal. Is there a way to do this?
Click to expand...

Since Access tables do not have record numbers, and since the count displayed
on the form is dynamic (changing if you filter the form or base the form on a
query), No. And it's pointless to try, frankly!

Autonumber fields will ALWAYS have gaps; generally they should not be
displayed to the user at all, since seeing them will generate unrealistic
expectations like this one.

John W. Vinson [MVP]
 
Top