Concatenation returns Number instead of Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emerlita@shaw.ca - 08 May 2007 17:38 GMT

How can i fixed my unbound text (Concat of Address) with the control
source coming from the same table as what i have in the form that
returns the ID which is number instead of Text?

Reply to this Message

Klatuu - 08 May 2007 19:02 GMT

You question is not clear. Can you post the code you are using and perhaps a
more detailed description of what it is you want to do?

Signature

Dave Hargis, Microsoft Access MVP

> How can i fixed my unbound text (Concat of Address) with the control
> source coming from the same table as what i have in the form that
> returns the ID which is number instead of Text?

Reply to this Message

John W. Vinson - 08 May 2007 23:46 GMT

>How can i fixed my unbound text (Concat of Address) with the control
>source coming from the same table as what i have in the form that
>returns the ID which is number instead of Text?

By using an expression which refers to the data that you want to see.

As Klatuu says, we need a bit of help here! Are you perhaps using a Lookup
Field? If so, the field actually *contains* the number, not the text; that
simple fact is concealed from view by the Lookup misfeature.

John W. Vinson [MVP]

Reply to this Message

Klatuu - 09 May 2007 00:22 GMT

misfeature

I have just added a new word to my lexicon.

Signature

Dave Hargis, Microsoft Access MVP

> >How can i fixed my unbound text (Concat of Address) with the control
> >source coming from the same table as what i have in the form that
[quoted text clipped - 7 lines]
>
> John W. Vinson [MVP]

Reply to this Message