asked on

How do I store multiple values, entered by end-user within a single field on form, per record?

Using Access 2010, I am looking for a simple, built-in feature to store multiple values (unpredictable) within a single field per record.

As an example, Record_ID #100 has a field called VALUE_FIELD. The form currenlty shows a single field called 'Value Field' to the end user. The user can enter a single value. Well, I just discovered that the user must enter multiple values per record, so each value can be searched independently. The values will look like A123456, A78910, C78236, B12645. This cannot be a multiple value lookup field because the values changes everyday and are generated by another system. Is there feature built into Access 2010 to set this up?

I am a novice Access developer and prefer NOT to use custom VBA. Thanks in advance.

Rey Obrero (Capricorn1)

select the textbox in the design view of the form, then hit F4
select the Other Tab

look for the property Enter Key Behavior and select the value New Line in field

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

1Etchedman

ASKER

Thank you Matthewspartick. While waiting for a reply, I created a separate Table called 'ValueTable'. I then created a subform based on this table and added it to the Main Form. Now I can add multiple values to a separate table, along with the RecordID so I know which record hold their related values. This makes a lot more sense and will allow for straight-forward queries down the road.

Much appreciated confirmation from you, it was a solid suggestion