How do I set a field

's Computer Specifications

I need to set a field so that it will only accept certain code letters ie SP
or AD or PP does anyone know how I do this please.

's Computer Specifications

Create a Combo with this values, and set the Limit to list property of the
combo to Yes.

--
\\// Live Long and Prosper \\//
BS"D

"Sue" wrote:

> I need to set a field so that it will only accept certain code letters ie SP
> or AD or PP does anyone know how I do this please.

's Computer Specifications

That will not only limit input to the desired codes, it lets users select
the code from a list which is a good thing to do for them.

"Ofer" <(E-Mail Removed)> wrote in message
news:67B9DABB-AEA7-463E-8DE3-(E-Mail Removed)...
> Create a Combo with this values, and set the Limit to list property of the
> combo to Yes.
>
> --
> \\// Live Long and Prosper \\//
> BS"D
>
>
> "Sue" wrote:
>
> > I need to set a field so that it will only accept certain code letters
ie SP
> > or AD or PP does anyone know how I do this please.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Field Property (OldValue) not available in Field Object defined withDim As Field?	insomniux	Microsoft Access VBA Modules	2	11th Apr 2009 02:19 PM
In a sub-form : when entering a field, verify if another field is true, if so show a MsgBox + set focus on another field	Céline Brien	Microsoft Access Forms	4	14th May 2008 03:30 PM
I want to combine a date field and a time field into 1 field.	Bob Quintal	Microsoft Access	4	28th Sep 2007 06:29 PM
On a report, print field A or field B based on value in field C	=?Utf-8?B?R2FyeSBGcmFj?=	Microsoft Access Reports	4	1st Aug 2007 08:10 PM
2 Related field or Auto fill up 2nd field after 1st field entered	=?Utf-8?B?S2FvbGk=?=	Microsoft Access Getting Started	1	17th Sep 2006 11:40 AM