Combo box- joining two fields for display

G

Guest

I just returned to work after an Access course and I'm trying to implement
what I learnt.

I learnt how to join two fields together for display in a combo box (and I
have the code below) but I don't know where to put the code!! Is it under
format? properties? Everything I try isn't working.

Name: [fieldname] & " " & " " [fieldname]

Please help!!
 
J

John Vinson

I just returned to work after an Access course and I'm trying to implement
what I learnt.

I learnt how to join two fields together for display in a combo box (and I
have the code below) but I don't know where to put the code!! Is it under
format? properties? Everything I try isn't working.

Name: [fieldname] & " " & " " [fieldname]

Please help!!

This code - or the simpler code

[fieldname] & " " & [fieldname]

if you want two spaces rather than one - would simply be typed into a
vacant Field cell in the Query that you're using as the combo's row
source.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top