Combo Box Shows Values on Text box (1 Viewer)

stu_c · Aug 22, 2019

Hi all
sorry to bombard today!
I have a combo box with 3 fields within, when a user selects from the drop down list I want a text box to show one of the other columns within the text box.

I have changed the control source of the text box to the combo box name but I cannot get it to show a different column apart from column1

arnelgp · Aug 22, 2019

three column:

1st column you refer as cboName.Column(0)
2nd column, cboName,Column(1)
…

the combobox is zero (0) based.

Uncle Gizmo · Aug 22, 2019

In addition to Arnelgp's advice, see Nifty Access Website Here:-

"Display Data from a Combobox in a Textbox"
https://www.niftyaccess.com/display-data-from-a-combo-box-in-a-text-box/

Sent from my Pixel 3a using Tapatalk

stu_c · Aug 28, 2019

Thank you guys!
I know how to put different information from different fields into one text for example
=[COMBOBOX1] & [COMBOX2]

Is it possible for them to be on different lines in the text box?

arnelgp · Aug 28, 2019

add vbCrLf to your expression:

=[combobox1] & vbCrLf & [combobox2]

theDBguy · Aug 28, 2019

stu_c said:
Thank you guys!
I know how to put different information from different fields into one text for example
=[COMBOBOX1] & [COMBOX2]

Is it possible for them to be on different lines in the text box?

Hi. If vbCrLf doesn't work, you could try it this way:

Code:

=[Combo1] & Chr(13) & Chr(10) & [Combo2]

Hope it helps...

stu_c · Aug 29, 2019

theDBguy said:
Hi. If vbCrLf doesn't work, you could try it this way:

Code:

=[Combo1] & Chr(13) & Chr(10) & [Combo2]

Hope it helps...

thank you this worked, are you able to explain what the relevance of
Chr(13) & Chr(10) is just for future reference?

moke123 · Aug 29, 2019

thank you this worked, are you able to explain what the relevance of
Chr(13) & Chr(10) is just for future reference?

take a look here ... https://www.techonthenet.com/access/functions/string/chr.php
and here ... https://www.techonthenet.com/ascii/chart.php

theDBguy · Aug 29, 2019

stu_c said:
thank you this worked, are you able to explain what the relevance of
Chr(13) & Chr(10) is just for future reference?

Hi. Glad to hear you got it to work, and I see moke123 already answered your other question. Good luck with your project.

Combo Box Shows Values on Text box (1 Viewer)

stu_c

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Uncle Gizmo

Nifty Access Guy

stu_c

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

theDBguy

I’m here to help

stu_c

Registered User.

moke123

AWF VIP

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread