Field properties in table

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Field properties in table

Ronel has attended:
Access Introduction course

by - delegate Ronel [1 post] (2008 Jul 31 Thu, 16:35) Reply

example
Would like the product id to always start with P and followed by 3 auto numbers.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: field properties in table

by - trainer Pete platinum contributer [816 posts] (2008 Aug 1 Fri, 08:03) Edited on 2008 Aug 1 Fri, 08:06 Reply

Hi Ronel,
Thank you for your post and welcome to the forum, in answer to your request,
You won't be able to combine text with an autonumber field. What you can do is create a unbound text box that will concantenate the text you want to display and the autonumber field number and use that to display to the user.

In your forms On Current event you can keep the unbound text box in sync with the records displayed.

UnboundTextBox.Value = "Your Text (P)" & " " & [autonumberfield]

In your underlying table the product ID would have to be a standard autonumber.

If however you do not wish to use an AutoNumber ID then you can utilise a combination of the Input Mask and the Validation Text boxes: in the Input Mask box type >L000
and in the Validation Rule type Like "P???"

If you then apply the Primary Key to this field and ensure No Duplicates it will allow you to only enter P followed by three numbers.

I hope that has helped, sorry about the AutoNumber though.

regards Pete
.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

Training by application

Main information pages

Field properties in table

Related articles

Access tip:

Random sampling