ListBox Display Problem

[DS]

I have a Listbox that is based on a Query.
The Query is based on 4 Different Queries pulling one field from each
into a field called ALL.

All: [VoidTableQ].[TableName] & [VoidStaffQ].[Staff] &
[VoidPNameQ].[PName] & [VoidCussQ].[Cuss]

This works fine. The problem is that the last 2 fields [PName] and
[Cuss] display in the ListBox with a space in front of them.

PName is a single field and Cuss is an Expression combining First Name
and Last Name.

TableName is numbers. And Staff is an Expression combining First Name
and Last Name...these are fine. Am I doing something wrong?

1 [TableName]
2 [TableName]
Jay Thomase [Staff]
Ron Howard [Cuss]
Tammy Wright [Staff]
Joey [PName]

This is how it looks.
Thanks
DS

 

[DS]

I have a Listbox that is based on a Query.
The Query is based on 4 Different Queries pulling one field from each
into a field called ALL.

All: [VoidTableQ].[TableName] & [VoidStaffQ].[Staff] &
[VoidPNameQ].[PName] & [VoidCussQ].[Cuss]

This works fine. The problem is that the last 2 fields [PName] and
[Cuss] display in the ListBox with a space in front of them.

PName is a single field and Cuss is an Expression combining First Name
and Last Name.

TableName is numbers. And Staff is an Expression combining First Name
and Last Name...these are fine. Am I doing something wrong?

1 [TableName]
2 [TableName]
Jay Thomase [Staff]
Ron Howard [Cuss]
Tammy Wright [Staff]
Joey [PName]

This is how it looks.
Thanks
DS

Its gotten stranger. Whenever I move the expression around, it always
the last 2 hat get a space in fornt of them!!!!!! What can I do!!!
Thanks
DS

 

[DS]

I have a Listbox that is based on a Query.
The Query is based on 4 Different Queries pulling one field from each
into a field called ALL.

All: [VoidTableQ].[TableName] & [VoidStaffQ].[Staff] &
[VoidPNameQ].[PName] & [VoidCussQ].[Cuss]

This works fine. The problem is that the last 2 fields [PName] and
[Cuss] display in the ListBox with a space in front of them.

PName is a single field and Cuss is an Expression combining First Name
and Last Name.

TableName is numbers. And Staff is an Expression combining First Name
and Last Name...these are fine. Am I doing something wrong?

1 [TableName]
2 [TableName]
Jay Thomase [Staff]
Ron Howard [Cuss]
Tammy Wright [Staff]
Joey [PName]

This is how it looks.
Thanks
DS

Its gotten stranger. Whenever I move the expression around, it always
the last 2 hat get a space in fornt of them!!!!!! What can I do!!!
Thanks
DS

Fixed! I used the AllTrim() Function

Function Alltrim(strString As String) As String
Alltrim = LTrim(RTrim(strString))
End Function

Never heard of this one before!
DS

 

[Dirk Goldgar]

I have a Listbox that is based on a Query.
The Query is based on 4 Different Queries pulling one field from each
into a field called ALL.

All: [VoidTableQ].[TableName] & [VoidStaffQ].[Staff] &
[VoidPNameQ].[PName] & [VoidCussQ].[Cuss]

This works fine. The problem is that the last 2 fields [PName] and
[Cuss] display in the ListBox with a space in front of them.

PName is a single field and Cuss is an Expression combining First Name
and Last Name.

TableName is numbers. And Staff is an Expression combining First Name
and Last Name...these are fine. Am I doing something wrong?

1 [TableName]
2 [TableName]
Jay Thomase [Staff]
Ron Howard [Cuss]
Tammy Wright [Staff]
Joey [PName]

The expression for the calculated field [All] shouldn't introduce any
spaces, so I'm guessing it's in the expressions you say are used to
calculate [Staff] and [Cuss].