How do I define a text array field in design view?

[CdnRebel]

I am trying to create an empty table to be populated from a form which offers multiple checkbox selections, how do I define the field in design view?

 

[KenReay]

Hi

You cannot have an array in a table

Nearest you could get would be to define a list of columns so

Option1
Option2
...etc

you could then write code to treat this as an array eg

For i = 1 to n
Rs!("Option" & i) = etc
Next i

but without knowing your application, not sure that this is what you should be doing, repeating sets of data within a row is not usually a good idea in databse design terms.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[CdnRebel]

Ken,
Thanks for the help. I was hoping that the optional multiple selections for a particular choice on my form could be stored in an array on the table that I was creating for that purpose. It's just a school exercise, but I wanted to know how to handle it should the situation come up again. I will try your suggestion.

CdnRebel