Question Multiple Values from Listbox in Textbox on a Report

[Oscar Mike]

Hi,

I'm banging my head up against a wall for this one :banghead:, I'm sure the answer is easy but it's not coming to me.

Basically what I have is a form where a user has a drop down combo box that he can pick more than one value.

I then want to take what he has inputed e.g. Option1, Option2 and put that on a report in an unbound text box with another field value.

For example
=[Field1] & "/" & Option1/Option2

Those forward slashes are quite important aswell, so any solution would need to include those.

I look for your assistance Access gurus. Much obliged.

 

[essaytee]

Hi,

I'm banging my head up against a wall for this one :banghead:, I'm sure the answer is easy but it's not coming to me.

Basically what I have is a form where a user has a drop down combo box that he can pick more than one value.

I then want to take what he has inputed e.g. Option1, Option2 and put that on a report in an unbound text box with another field value.

For example
=[Field1] & "/" & Option1/Option2

Those forward slashes are quite important aswell, so any solution would need to include those.

I look for your assistance Access gurus. Much obliged.

Unless this is a feature of a later version of Access, a Combo Box only allows for one row to be selected.

 

[CJ_London]

Your thread refers to a listbox, your post to a combo box. Which is it?

If the latter are you referring to a multivalue field?

If you cannot be clear about what you have and what you are trying to achieve how do you expect to get an answer?

Use correct terminology, and provide some before and after sample data