RE: Autonumber - with text
- From: Bill <Bill@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 6 Jul 2008 19:51:06 -0700
Dave,
I'm following your example and on the form I'm getting an error. Where does
it refer to the table? I've created a table (Table1) with two columns -
IR_Year and IR_Number. Then I created a form with a text box and placed the
following in Control Source
=Right(CStr([IR_Year]),2) & CStr(Format([IR_Number],"0000"))
thx
"DaveT" wrote:
Not directly, but you can make it appear that way to users on reports and.
forms.
I had similar issue with a quote program. Put two field in table:
QuoteYear, Default Value = Year(Date())
This plugs the year when record is added.
QuoteNumber, Autonumber
Then on form (or report), use text box with Control Source =
=Right(CStr([QuoteYear]),2) & CStr(Format([QuoteNumber],"0000"))
This would show, for example, 080251
In your case, add & "-" & , and you would get 08-0251
--
Dave Thompson
Allen, TX
US
"Bill" wrote:
Any way to create a auto number field with a text field in it? I have a
field called "RecordID" which is formated as XX-XXX (08-111). Since I need
the '-' dash in the field, it must be a text field. But I want it to
autonumber and I want to pick the number where it starts.
Any chance of this??
Thanks,
Bill
- Prev by Date: Re: Calling a Function in a Query and Form
- Next by Date: Carry forward balance of account
- Previous by thread: RE: Autonumber - with text
- Next by thread: Re: Sending Email Message from Access 2003
- Index(es):
Relevant Pages
|
