Object doesnt support this method error

[NightWalker]

I have a report that is giving me the error "Object doesn't support this method"

Here is the offending code.

txtPre1 = Forms!frm_343DataSheet.Controls!txtPre1 & " " & Forms!frm_343DataSheet.Controls!cboPreUnit1 & Forms!frm_343DataSheet.Controls!OHM

if I remove the last concatenation it works like this:

txtPre1 = Forms!frm_343DataSheet.Controls!txtPre1 & " " & Forms!frm_343DataSheet.Controls!cboPreUnit1

I don't understand why it will not let me add the last part. The last one is a label with the Ω symbol in it.

Thank you for any help on this.
Walker

[NightWalker]

Figured it out finally. Here is the correct code if you want to use the caption in a label.

txtPre1 = Forms!frm_343DataSheet.Controls!txtPre1 & " " & Forms!frm_343DataSheet.Controls!cboPreUnit1 & Forms!frm_343DataSheet.Controls!OHM.caption

Because labels do not have a default like textboxes and comboboxes, you have to tell it you want to use the caption.
Hope this helps someone else.

[aytee111]

Interesting! Thanks for posting the solution.