MS Access Multiple Values For A Single Field: A New Data Option From Version 2007

MS Access Multiple Values For A Single Field: A New Data Option From Version 2007

With traditional Access databases, storing data values in a field were very ‘single-minded’! However with the introduction of version 2007, Access multiple values can be achieved into one field using the new element called ‘Allow Multiple Values‘ which is a new option available when using the Lookup Wizard feature to create either a drop-down Combo box or List box.

For the ‘purist’ database developer, you do not even need to use the wizard tool as there are new properties available via the ‘Lookup‘ tab for each field in your table design view.

access multiple values

Before I step you through the very basics of creating a multiple value input field, one needs to Continue reading “MS Access Multiple Values For A Single Field: A New Data Option From Version 2007”