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

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
 
S

Stuart Grant

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

Stuart
 
R

Rick Brandt

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

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.
 
S

Stuart Grant

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

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.
.
 
S

Stuart Grant

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
 
J

Jerry Whittle

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.
 
A

Albert D. Kallal

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....
 
K

kirschbaum-karzbon

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top