MS access help

[Ian]

Can anyone tell me how to concatinate 2 fields on a report using VBA?

been ages since i done VBA so i tried

txt1.text = "txt2.text" & txt3.text"

but i must be doing something wrong, anyone any ideas?

 

[James]

txt1.Text = txt2.Text & txt3.Text

No quotes I don't think
Unless you want a gap between the two in which case its

txt1.Text = txt2.Text & " " & txt3.Text

 

[Ian]

nope

 

[James]

tried doing it a long winded way?

Dim strText as String

strText = txt2.Text & txt3.Text

txt1.Text = strText

 

[Ian]

nah doesnt work either, the net is useless too :|

 

[James]

Oh wait!

It's not txt2.Value is it??

 

[Ian]

maybe, ill try. I hate VBA its so fiddly, VB is FAR better :s

 

[Ian]

nah doesnt work

 

[rlees85]

is it not just txt2?

txt1 = txt2 & txt3

or

txt1 = txt2 & " " & txt3

 

[Ian]

nope, I say offically... VBA sucks balls :\