How to suppress "(Autonumber)" text

[Leif]

I have a combo field that displays a number from an autonumber field. Before
I create a record the text "(Autonumber)" is displayed in the combo field.
Is there a way to suppress this so that the field is simply blank when no
record has yet been created? Thanks.

 

[Linq Adams via AccessMonster.com]

If you're running ACC2000 or later, use Conditional Formatting for the
Combobox

Condition1

Expression Is IsNull(YourFieldName)

Now set the font/fore color to white

 

[Linq Adams via AccessMonster.com]

I'm sorry, forgot he square brackets:

Expression Is IsNull([YourFieldName])

 

[Leif]

Thanks Linq. Extremely clever.

Regards,
Leif

 

[Linq Adams via AccessMonster.com]

Glad I could help!

 

[Rick Brandt]

I have a combo field that displays a number from an autonumber field. Before
I create a record the text "(Autonumber)" is displayed in the combo field.
Is there a way to suppress this so that the field is simply blank when no
record has yet been created? Thanks.

Since AutoNumbers are not user editable, what is the point of using a ComboBox
for the field?

In a TextBox which is probably what you should be using all you need to do is
use an expression...

=[FieldName]

....instead of the field name by itself as your ControlSource and the
"(AutoNumber)" will no longer be displayed.

Using such an expression has the result of making your control non-editable, but
as stated above that is not a concern for an AutoNumber since it is not editable
anyway.