Spacing Issuses

[Guest]

I have an unbound texbox that combines 9 fields,
=[field1]&" "&[field2]& " "&[field3] Exc....

EX: If I have something in field1 and something in field9 it shows up like
this on the report: 1 9
Is there a way I can have it show up like this?: 1 9

(Only 2 fields of the 9 will ever show, but they change all the time)

Thanks!

 

[Rick B]

=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

 

[Guest]

Thank you for the responce, but I get #error in the report now.

This is what I put in:
=([1NoActionReq]+" ") & ([2ImplementMaintenanceRepairs]+" ")

=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

--
Rick B

I have an unbound texbox that combines 9 fields,
=[field1]&" "&[field2]& " "&[field3] Exc....

EX: If I have something in field1 and something in field9 it shows up like
this on the report: 1 9
Is there a way I can have it show up like this?: 1 9

(Only 2 fields of the 9 will ever show, but they change all the time)

Thanks!

 

[Rick B]

I know that works with text fields. If your field is numeric, then it may
not work.


--
Rick B

Thank you for the responce, but I get #error in the report now.

This is what I put in:
=([1NoActionReq]+" ") & ([2ImplementMaintenanceRepairs]+" ")

=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

--
Rick B

I have an unbound texbox that combines 9 fields,
=[field1]&" "&[field2]& " "&[field3] Exc....

EX: If I have something in field1 and something in field9 it shows up like
this on the report: 1 9
Is there a way I can have it show up like this?: 1 9

(Only 2 fields of the 9 will ever show, but they change all the time)

Thanks!

 

[Guest]

AHH Thats it!
My fields were numeric, I changed them to text and it works perfect now!
Thank You Rick

I know that works with text fields. If your field is numeric, then it may
not work.


--
Rick B

Thank you for the responce, but I get #error in the report now.

This is what I put in:
=([1NoActionReq]+" ") & ([2ImplementMaintenanceRepairs]+" ")

=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

--
Rick B



I have an unbound texbox that combines 9 fields,
=[field1]&" "&[field2]& " "&[field3] Exc....

EX: If I have something in field1 and something in field9 it shows up like
this on the report: 1 9
Is there a way I can have it show up like this?: 1 9

(Only 2 fields of the 9 will ever show, but they change all the time)

Thanks!