[AccessD] Regarding multi-value field, from a reader

Tina Norris Fields tinanfields at torchlake.com
Thu Nov 1 13:51:35 CDT 2012


Well, for what it's worth, I agree with everybody who said don't use 
multi-value fields!  Geez, we go to lots of trouble to normalize our 
data and then Access arrives with new specialties that at least look 
like the destruction of normalization!  Dang!
T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787

On 10/31/2012 7:08 PM, Susan Harkins wrote:
> Received the following from a reader:
>
> "I set up a multivalued field in Access 2010 using a List Box and 
> providing a Value List with values M,T,W,R,F. Everything works fine 
> but for one problem. When I chose M, W, F from my list, th 
> emultivalued filed reads F, M, W ... i.e., the entries are sorted left 
> to right whereas I want them to show up as M, W, F. Is there a way to 
> do this?"
>
> =====Other than learning the basics so I could write about them, I 
> don't use them and have almost no experience. Anyone have a quick and 
> easy answer? I'm going to do a little research, but if anybody knows, 
> please share!
>
> Thanks!
> Susan H.



More information about the AccessD mailing list