How do I get rid of "Auto Number" in forms ?

  • Thread starter Thread starter Stuart Grant
  • Start date Start date
S

Stuart Grant

I have a table with 6 columns. The first,"ID", I set the format to
AutoNumber. It works fine although at the foot of the table, it has
"AutoNumber" and the default values in the other columns.

When I make a form to display the table, it prints "AutoNumber" as the
last item in the ID column, and when I make a Data Entry form it also shows.

How do I get rid of it ? I don't want the words "AutoNumber" to appear
anywhere. I just want it to function.

Stuart
 
Sorry for a mistake in the first paragraph. I set the DATATYPE to
AutoNumber, the FORMAT to General Number.

Stuart
 
I have a table with 6 columns. The first,"ID", I set the format to
AutoNumber. It works fine although at the foot of the table, it has
"AutoNumber" and the default values in the other columns.

When I make a form to display the table, it prints "AutoNumber" as the
last item in the ID column, and when I make a Data Entry form it also
shows.

How do I get rid of it ? I don't want the words "AutoNumber" to appear
anywhere. I just want it to function.

Stuart
Click to expand...

Instead of using the field name as the ControlSource for the TextBox on
the form use an expression...

=[FieldName]

That causes it to behave normally when there is a number, but it will be
blank on a new record.
 
Thanks Rick. That did it. Next problem. When I ckick on this text box
on the form, it changes to Black on Black. When I move one down, it
returns to normal but the new one with the focus turns black on black.

There is no event expression for Got Focus or Lost Focus.

I'm sorry to be so dim but can you explain?

Stuart

Rick said:
I have a table with 6 columns. The first,"ID", I set the format to
AutoNumber. It works fine although at the foot of the table, it has
"AutoNumber" and the default values in the other columns.

When I make a form to display the table, it prints "AutoNumber" as the
last item in the ID column, and when I make a Data Entry form it also
shows.

How do I get rid of it ? I don't want the words "AutoNumber" to appear
anywhere. I just want it to function.

Stuart
Click to expand...

Instead of using the field name as the ControlSource for the TextBox on
the form use an expression...

=[FieldName]

That causes it to behave normally when there is a number, but it will be
blank on a new record.
.
Click to expand...
 
I sometimes want to get the number from the form so took Rick Brandz's
advice but appreciate a busy fellow like you taking time to help a
novice. Thanks.

Stuart
 
Don't print forms. Instead create a report for printing. You could even put a
command button on the form so that it will print just the record showing.

Reports are made for printing. Forms? Not so much.
 
Any particular reason why you don't just bring up the form in design mode
and delete the id text box?

You really don't need to display it for the form to function correctly....
 
Uzytkownik "Stuart Grant said:
I have a table with 6 columns. The first,"ID", I set the format to
AutoNumber. It works fine although at the foot of the table, it has
"AutoNumber" and the default values in the other columns.

When I make a form to display the table, it prints "AutoNumber" as the
last item in the ID column, and when I make a Data Entry form it also
shows.

How do I get rid of it ? I don't want the words "AutoNumber" to appear
anywhere. I just want it to function.

Stuart
Click to expand...
 
Back
Top