more concatenation grief

[potts]

Having finally resolved what I thought was the more difficult issues concerning concatenation, I am once again bemused.

Here's the basics...

I have an unbound textbox that contains concatenated information from several fields in a table. Didn't see this as a major issue as I've done it before. However, one of the fields isn't diplayed properly - only the first character is shown regardless of where the field is placed within the concatenation.

for example . . .

concatenation:

=field1&".."&field2&".."&field3

should look like:

fine..trees..11-20

instead I get:

fine..trees..1

Field3 is a text field. And like I said, it doesn't matter in which position in the sequence it is placed.

Anyone know how to get yourself out of this one?

 

[WayneRyan]

Hi potts,

Since the problem revolves around field3 (no matter where
it is located) then the resolution must center around him.

Is its length attribute the same as the others?
How do you know its real value?
Since its unbound, could the thing that populates it trim it?

Can you set a breakpoint (Like Detail_OnFormat) and watch it?

let me know,
Wayne