Combo box- joining two fields for display

  • Thread starter Thread starter Guest
  • Start date Start date
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!!
 
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!!
Click to expand...

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]
 
Back
Top