Spacing Issuses

J

Joel

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!
 
J

Joel

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

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

Rick B said:
=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

--
Rick B



Joel said:
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!
Click to expand...
Click to expand...
 
R

Rick B

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


--
Rick B



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

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

Rick B said:
=([field1]+" ") & ([field2]+" ") & ([field3]+" ")...

--
Rick B



Joel said:
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!
Click to expand...
Click to expand...
Click to expand...
 
J

Joel

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

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


--
Rick B



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

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

Rick B said:
=([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!
Click to expand...
Click to expand...
Click to expand...
 
Top