3 combo box to a single string

[LAazsx]

Hi, I have three combo boxes which i will use for entering a date. mm/dd/yyyy. I've already made an entered their values but how do i combine them to a single string to be stored?

[ajetrumpet]

try:

combo1 & combo2 & combo3

or "/" in between if the combos are being used for each part of the date.

[LAazsx]

thanks. for the quick reply. i shall try it out later.

EDIT: sorry but how do i use this?

[ajetrumpet]

that's vba code behind a form. when referring to controls, you don't have to use "me." as the qualifier.

concatenation in vba is produced by the ampersand symbol. "&"

so when you combine the values together, throw it wherever you want to, by whatever method, vba or not, that you want to.

[LAazsx]

So i should have something like this?

vDate = combo1 & ,"/", & combo2 & ,"/", & combo3

[ajetrumpet]

NO.

no commas sir, just the ampersands. e.g. -

field1 = "1"
field2 = "15"
field3 = "2010"

to get a date (each field is a combo box name):

myvariable = field1 & "/" & field2 & "/" & field3

if you get a type mismatch error when you're doing it, you may have to use:

myvariable = cstr(field1) & "/" & cstr(field2) & "/" & cstr(field3)

[LAazsx]

i see. thank you for the correction.

[ajetrumpet]

you bet!