multivalued lookup column and forms

[Phyliss]

I have a multivalued lookup column and I am trying to make it display in 3
columns in my form (I'm using the justified view). I have tried setting it to
3 columns in the properties but it only shows the choices in the first column
and the other two columns are blank. How do I get the choices to "spread out"
across all three columns so that the user does not have to scroll down to see
all of the choices?

thanks,
Phyliss

 

[Arvin Meyer [MVP]]

Multi-value fields are an effort by the Access development team at Microsoft
to make Access compatible with SharePoint. SharePoint cannot handle linked
tables, so it was though that this might be a solution. Under the covers,
the database is a relational one, but it is not possible for a developer to
get under the covers. As a result, we have an abundance of problems like the
one you have. Worse yet, lookups belong it queries, not in tables. Tables
are for storing data and maintaining data integrity.

http://www.mvps.org/access/lookupfields.htm

The best solution is to redesign your table structure with linked relational
tables that have a separate row for each value. You can parse out the values
with queries so you won't have to do the data entry all over again. If you
can't figure out how, or need additional help with design or functionality,
please post back in detail.