Please this is urgent....

[Kavinga]

I have tried to use MS Office help to create a multivalued field... But I
have a problem with the step Number 6... -

Under Do you want to store multiple values for this lookup?, select the
Allow Multiple Values check box.

When I am trying it I dont get a check box like that......

Please somebody help me.....

 

[George Nicholson]

Are you using Office 2007? Afaik, that the first version to have a
multivalue option, but you might not realize that if you are looking at
instructions online somewhere.

 

[Evi]

I don't have 2007 but so far I haven't found anything in Access which relies
entirely on the Wizard.
which can sometimes be very flighty.
Have you read the articles below to see if they contain details which may be
badly worded in Help?
http://www.databasedev.co.uk/multivalued-fields.html
http://office.microsoft.com/en-us/access/HA100140981033.aspx

The first one is particularly clear.

Please reconsider using a Lookup in your table, if that is what you are
planning to do. They cause no end of problems.

Evi

 

[Evi]

In this same newsgroup, Allen Browne answered this question in a message
No 'allow multiple values check box' - Allen Browne
He states:

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.

Evi