AutoNumber Field?

[T588]

I have an AutoNumber field on a form. Prior to an AutoNumber being generated the word "(AutoNumber)" is displayed in the field - is there any way to hide this.

Thanks
Vince

 

[jca]

No but you could hide this textbox and create another textbox which will contain the value of the autonumber textbox only if it's a number.

In the new textbox insert this in the source:

=IIf(IsNumeric([txtAutoNumber]);[txtAutoNumber];"")

 

[T588]

Sounds like a winner to me! Thanks......Vince

 

[neileg]

In fact if you just set the source to =[txtAutoNumber] that will do the trick, since when the field shows "(AutoNumber)" it is null.

 

[T588]

Thanks...........................