AutoNumber in Textbox

  • Thread starter Thread starter an
  • Start date Start date
A

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
 
an said:
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?
Click to expand...

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.
 
or, use conditional formatting to set the background and foreground both to
white!

Rick Brandt said:
an said:
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?
Click to expand...

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.
Click to expand...
 
Ok, MC.
Many thanks
an
-----Original Message-----
or, use conditional formatting to set the background and foreground both to
white!

Rick Brandt said:
Instead of binding the TextBox directly to the
Click to expand...
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.
Click to expand...


.
Click to expand...
 
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?
Click to expand...

Just don't show the autonumber on the form AT ALL. The user can't edit
it and shouldn't use it!
 
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?
Click to expand...

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.


.
Click to expand...
 
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?
Click to expand...

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.


.
Click to expand...
 
Back
Top