473,395 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Auto Number Formatting

AllusiveKitten
Hi All

I have just come up with an issue that requires a formatted auto number ie QSTR001, QSTR002 etc, is it possible for this field to be directly put into the access table as an auto number?

Or do I have to Conconate it in the Report? With the QSTR & "#"

If I do have to conconate it, how do I code a single digit such as 1 to be shown as 001?

Thank again for you help
AK
Oct 18 '07 #1
4 1452
ADezii
8,834 Expert 8TB
Hi All

I have just come up with an issue that requires a formatted auto number ie QSTR001, QSTR002 etc, is it possible for this field to be directly put into the access table as an auto number?

Or do I have to Conconate it in the Report? With the QSTR & "#"

If I do have to conconate it, how do I code a single digit such as 1 to be shown as 001?

Thank again for you help
AK
You can store the next Formatted Number in sequence directly in the Table, but it cannot be an AutoNumber. It must be stored as Text and should probably be the Primary Key. The Formula would be
Expand|Select|Wrap|Line Numbers
  1. "QSTR" & Format$(Val(Right$(DLast("[Your_Field]", "tblYour_Table"), 3))+1,"000")
Oct 19 '07 #2
Thank you ADezzi
Your a great help.
AK
Oct 19 '07 #3
ADezii
8,834 Expert 8TB
Thank you ADezzi
Your a great help.
AK
Always glad to help AK. Please don't mind the Shortcut, it's a little easier than typing AllusiveKitten (LOL).
Oct 19 '07 #4
Always glad to help AK. Please don't mind the Shortcut, it's a little easier than typing AllusiveKitten (LOL).
I understand what you mean, why do you think I only type AK.....lol, I am just as lazy.....hehe
Oct 19 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Seth | last post by:
How can I completely turn off the auto formatting of Html in Visual Studio 7? I have tried all possible combinations (at least I think I have) of the Tools / Options / Text Editor / HTML XML /...
0
by: sonic_soul | last post by:
silly, but i thought i disabled auto formatting in Options > Text Editor > HTML/XML > Format > Apply automatic formatting. after creating a huge aspx page maticulously formatted i switch to...
1
by: Zorpiedoman | last post by:
I have many different projects and solutions I am working on. All but one of them work fine. One of them, for a reason I can't figure out, has stopped 'auto formatting' as I work in the...
2
by: Irwinsp | last post by:
Hi All, I have a form with an auto number field displayed. The field looks great except when the user is entering a new record. The field then has the text "auto number" in it. Is there a...
2
by: John Holmes | last post by:
I saw a similar post that went unanswered about a month ago. I am annoyed by the auto-formatting that occurs when creating my form. I'll make changes to the code (HTML tab) and then view them in...
2
by: hb | last post by:
Hi, The auto-formatting of HTML code in Visual Studio.Net 2003 is very annoying! I already unchecked the 2 checkboxes in "Apply Automatic Formatting" section located at: Tools-->Options-->Text...
6
by: TORQUE | last post by:
Hi, Can anyone tell me how to remove or change the automatic rounding of numbers in a box. The box has already been tested with General Number, Fixed, and Standard Formatting with the decimal...
1
by: Sven Fischer | last post by:
After installation of Visual CSharp Studio the current settings of the source code editor are not suitable for me. The brackets are automaticlly set in front of the lines e.g. if (.......) {...
4
by: Harris Kosmidhs | last post by:
Consider the following HTML: <div class="links"> <img src="linkimages/logo.gif"> <h2>title</h2> <span><a target="_blank" href="http://">http://</a></span> <p>description of link</p> </div> ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.