No 'allow multiple values check box'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Loane - 05 Jun 2007 00:34 GMT

Access 2007
Trying to create an input form which has a field which will populate a
multivalue field in a table. However I cannot get the wizard to display the '
allow multiple values check box '. This is true for the table and the form.
The database was first created in the 2003 version and then converted, might
this be the problem???
Help please!!

Reply to this Message

KARL DEWEY - 05 Jun 2007 00:45 GMT

Maybe you are thinking of a numerical field used with an Option Group on a
form.
Or are you thinking of a triple state checkbox on a form, that has
True/False/Null or Yes/No/Null as states.

Signature

KARL DEWEY
Build a little - Test a little

> Access 2007
> Trying to create an input form which has a field which will populate a
[quoted text clipped - 3 lines]
> this be the problem???
> Help please!!

Reply to this Message

Allen Browne - 05 Jun 2007 02:05 GMT

1. Make sure you have converted this to an ACCDB (not merely an MDB opened
with A2007.)

2. In table design view, select the field where you want multiple values.

3. In the lower pane, click the Lookup tab, and choose Combo as the Display
Control.

4. Set the Allow Multiple Values property to Yes.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Access 2007
> Trying to create an input form which has a field which will populate a
[quoted text clipped - 6 lines]
> this be the problem???
> Help please!!

Reply to this Message