AutoNumber in Textbox

[an]

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Thanks in advance.
an

 

[Gina]

As far as I know, nope

 

[Rick Brandt]

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Instead of binding the TextBox directly to the Autonumber field, bind it to
an expression that will give the same result.
=[AutonumberField] + 0

The above will display the same as the autonumber field except on a new
record where it will be blank.

 

[Malcolm Cook]

or, use conditional formatting to set the background and foreground both to
white!

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Instead of binding the TextBox directly to the Autonumber field, bind it to
an expression that will give the same result.
=[AutonumberField] + 0

The above will display the same as the autonumber field except on a new
record where it will be blank.

 

[an]

Ok, MC.
Many thanks
an

-----Original Message-----
or, use conditional formatting to set the background and foreground both to
white!

Instead of binding the TextBox directly to the

Autonumber field, bind it
to

an expression that will give the same result.
=[AutonumberField] + 0

The above will display the same as the autonumber field except on a new
record where it will be blank.

.

 

[John Vinson]

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Just don't show the autonumber on the form AT ALL. The user can't edit
it and shouldn't use it!

 

[an]

Ok!

Many thanks, RB
an

-----Original Message-----

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Instead of binding the TextBox directly to the Autonumber field, bind it to
an expression that will give the same result.
=[AutonumberField] + 0

The above will display the same as the autonumber field except on a new
record where it will be blank.


.

 

[an]

Thanks for your replay and sorry for my delay.
Your solution work fine!
an

-----Original Message-----

Hello!

I Have a form based on table with AutoNumber field.
When the field is empty (the last), the textbox show
us "AutoNumber".
Is possible to omit this message in Access 2K?

Instead of binding the TextBox directly to the Autonumber field, bind it to
an expression that will give the same result.
=[AutonumberField] + 0

The above will display the same as the autonumber field except on a new
record where it will be blank.


.