K
KenNiuM
Is it possible to have auto number in text data type?
If it is possible, please assist.
If it is possible, please assist.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wayne-I-M
No - you can't have an auto"number" as text. But you can convert it in a
query to text.
Is this what you're looking for or something else
eg
1234-ABC
ABC-WXYZ
etc
etc
query to text.
Is this what you're looking for or something else
eg
1234-ABC
ABC-WXYZ
etc
etc
K
KenNiuM
Nope. I was hoping to have a text field that operate the same function as a
auto number just that it is easier to program in visual studio.
Is there no way to this?
auto number just that it is easier to program in visual studio.
Is there no way to this?
K
Ken Sheridan
No, an autonumber is a long integer data type. You can format it to output
as a text value in a query, form or report, however. In a query you'd put
something like:
MyIDFormatted: Format([MyID],"00000")
to return it as a 5 character string with leading zeros. In a form or
report the ControlSource property of a text box would be:
=Format([MyID],"00000")
If you really need the column in the base table to be of text data type
you'd have to write code in a form's module to automatically increment its
value by 1 from the highest value currently in the column.
Ken Sheridan
Stafford, England
as a text value in a query, form or report, however. In a query you'd put
something like:
MyIDFormatted: Format([MyID],"00000")
to return it as a 5 character string with leading zeros. In a form or
report the ControlSource property of a text box would be:
=Format([MyID],"00000")
If you really need the column in the base table to be of text data type
you'd have to write code in a form's module to automatically increment its
value by 1 from the highest value currently in the column.
Ken Sheridan
Stafford, England
K
KenNiuM
Thanks! i got my answers already.
Hope you try to answer one of my other urgent question.
http://www.microsoft.com/office/com...46e-56269e6f6f19&cat=&lang=en&cr=US&sloc=&p=1
Hope you could help.
Hope you try to answer one of my other urgent question.
http://www.microsoft.com/office/com...46e-56269e6f6f19&cat=&lang=en&cr=US&sloc=&p=1
Hope you could help.
Ken Sheridan said:No, an autonumber is a long integer data type. You can format it to output
as a text value in a query, form or report, however. In a query you'd put
something like:
MyIDFormatted: Format([MyID],"00000")
to return it as a 5 character string with leading zeros. In a form or
report the ControlSource property of a text box would be:
=Format([MyID],"00000")
If you really need the column in the base table to be of text data type
you'd have to write code in a form's module to automatically increment its
value by 1 from the highest value currently in the column.
Ken Sheridan
Stafford, England
KenNiuM said:Is it possible to have auto number in text data type?
If it is possible, please assist.
W
Wayne-I-M
I want to have my query show transactions after the log in time. How do i do
it?
Just set the criteria as something like
--
Wayne
Trentino, Italia.
it?
Just set the criteria as something like
Make sure that the table is shown in the design grid[tableName]![LogInTime]
--
Wayne
Trentino, Italia.
KenNiuM said:Thanks! i got my answers already.
Hope you try to answer one of my other urgent question.
http://www.microsoft.com/office/com...46e-56269e6f6f19&cat=&lang=en&cr=US&sloc=&p=1
Hope you could help.
Ken Sheridan said:No, an autonumber is a long integer data type. You can format it to output
as a text value in a query, form or report, however. In a query you'd put
something like:
MyIDFormatted: Format([MyID],"00000")
to return it as a 5 character string with leading zeros. In a form or
report the ControlSource property of a text box would be:
=Format([MyID],"00000")
If you really need the column in the base table to be of text data type
you'd have to write code in a form's module to automatically increment its
value by 1 from the highest value currently in the column.
Ken Sheridan
Stafford, England
KenNiuM said:Is it possible to have auto number in text data type?
If it is possible, please assist.
B
BruceM
The courteous thing to do after people have tried to help, even if you found
the answer elsewhere, is to describe briefly the approach that worked. It
may be of benefit in the future to somebody seaching these postings.
the answer elsewhere, is to describe briefly the approach that worked. It
may be of benefit in the future to somebody seaching these postings.
KenNiuM said:Thanks! i got my answers already.
Hope you try to answer one of my other urgent question.
http://www.microsoft.com/office/com...46e-56269e6f6f19&cat=&lang=en&cr=US&sloc=&p=1
Hope you could help.
Ken Sheridan said:No, an autonumber is a long integer data type. You can format it to
output
as a text value in a query, form or report, however. In a query you'd
put
something like:
MyIDFormatted: Format([MyID],"00000")
to return it as a 5 character string with leading zeros. In a form or
report the ControlSource property of a text box would be:
=Format([MyID],"00000")
If you really need the column in the base table to be of text data type
you'd have to write code in a form's module to automatically increment
its
value by 1 from the highest value currently in the column.
Ken Sheridan
Stafford, England
KenNiuM said:Is it possible to have auto number in text data type?
If it is possible, please assist.
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.