Hiding Autonumber

[PharmaFun]

Hi there.

I have a form with an autonumber field in it. Is there a way for that field to be blank on my form until the auto number is there. Right now, it starts off with the text "(AutoNumber)" in there.

Thanks,
PharmaFun

 

[Wiszh]

If the field will be automatically filled, there is no need to display it at all. Set the visible property to false.

 

[PharmaFun]

Thanks for the reply Wiszh. Yes, it is to be automaticall filled, but I only want the value to be visible once it is atomatically filled. When the form is first opened, it says (AutoNumber) in there. Is there a way to obscure that text message and only show the number once it is generated?

Thanks,
PharmaFun

 

[natatbh]

Hi PharmaFun,

Try setting the Control Source property of the text box to the AutoNumber field in your table after the first record in the table is shown in the form. In other words, it should not be associated with the field in your table until there is a real value in there.

natatbh.

 

[PharmaFun]

Thanks man!