Replace null value

[shawnntjr]

Hi all,

Is there a code that will replace the empty fields by shifting the bottom fields up for access? I am planning to write a code that will delete unnecessary items in my database, however, that will cause the database to have "holes" in it.

 

[llkhoutx]

No, delete the row.

 

[smig]

What do you mean by "holes" exactly ?
Make sure you dont confuse fields with records.

 

[gemma-the-husky]

if you are referring to gaps in an autonumber sequence .... then there are loads of tips about what an autonumber is and isn't - the main thing being that it will not guarantee an intact sequence.

 

[smig]

with AutoNumber if add a record and delete it, even if it was the last record the AutoNumber won't get this number again.