If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting Autonumber
I am trying to set up a field in a database i'm creating
to generate a specific format the same way Autonumber will generate a 1 then a 2 and so on. I want my format to come out as J624C-742 then J624C-743 then J624C-744 and so on and so forth down the column as you need to enter a new record with that next number in the sequence. How would you do this? I've been working on it for a while but have gotten nowhere. |
#2
|
|||
|
|||
Formatting Autonumber
"Chris" wrote in
: I want my format to come out as J624C-742 then J624C-743 then J624C-744 and so on Case 1: the J624C- part is constant - don't store the prefix at all, but use the Format property of the text box set to something like "J624C-"000 Case 2: the prefix part is variable and has some meaning -- in which case it should be in its own field(s) you can simply contcatenate the parts on the forms and reports. Hope that helps Tim F |
#3
|
|||
|
|||
Formatting Autonumber
-----Original Message----- "Chris" wrote in : I want my format to come out as J624C-742 then J624C-743 then J624C-744 and so on Case 1: the J624C- part is constant - don't store the prefix at all, but use the Format property of the text box set to something like "J624C-"000 Case 2: the prefix part is variable and has some meaning - - in which case it should be in its own field(s) you can simply contcatenate the parts on the forms and reports. Hope that helps Tim F The J624C- part is constant, but i'm trying to get the 742 number to come up in sequential order. How do i do that? |
#4
|
|||
|
|||
Formatting Autonumber
wrote in
: The J624C- part is constant, but i'm trying to get the 742 number to come up in sequential order. How do i do that? Use an autonumber. If you need more control than an AN gives you, then there are lots of examples of VBA code that will generate equivalents. Try googling for "Access Custom Autonumbers". HTH Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Problems with Style formatting | terrapinie | Formatting Long Documents | 2 | July 7th, 2004 06:18 PM |
formatting individual columns for different languages, including double-byte characters | Sandra Rosenzweig | General Discussion | 1 | June 20th, 2004 01:08 PM |
Formatting Linked Excel Tables | Tammie | Tables | 7 | June 10th, 2004 10:25 AM |
Formatting (General to Number) | Tom R | Worksheet Functions | 5 | September 17th, 2003 08:49 PM |