Dumb question

[rlmorgan]

I have a form that is populated with a combo box. The form data is from a table that has an autonumber column. How can I stop the form from displaying (AutoNumber) in the field before the form is populated? This is strictly cosmetic.

 

[speakers_86]

So the autonumber displays (new)? Perhaps you can make the control unbound until the autonumber is not null.

 

[vbaInet]

You simply don't display the Auto Number field. Users don't really need to see it.

Or if you're so keen on your users still able to see the field, toggle the form's Allow Additions property. But that means you will need a button to do this.

 

[rlmorgan]

I think it's going to go away. The only reason that I added it was to show the users that they just used the Clone Record button and were now editing a new record.

Thanks for the help.

 

[vbaInet]

The user should know that they have just used the clone button. But you can always implement ways to make it obvious, e.g. by changing the button's Fore Colour until the cloned record is saved.