formatting fields

  • Thread starter Thread starter wondering
  • Start date Start date
W

wondering

I posted this in another section but no one was able to
help me. It seems like an easy question but I just cant
seem to figure it out.

I have a report that is linked to a query. This query
returns the County and State in a certain table. I have
both of these fields being displayed in a textbox on my
report as: = [County] & ", " & [State]

WHen I view the report though I get:

County1 , State

I need to get rid of that space in between. I have tried
using seperate text boxes for each of the fields but that
doesn;t work either. If you can think of anything for me
to do please let me know.


Thanks in advance
 
-----Original Message-----
I posted this in another section but no one was able to
help me. It seems like an easy question but I just cant
seem to figure it out.

I have a report that is linked to a query. This query
returns the County and State in a certain table. I have
both of these fields being displayed in a textbox on my
report as: = [County] & ", " & [State]

WHen I view the report though I get:

County1 , State

I need to get rid of that space in between. I have tried
using seperate text boxes for each of the fields but that
doesn;t work either. If you can think of anything for me
to do please let me know.


Thanks in advance
.
Click to expand...
At a glance it looks like the TEXT ALIGN property for the
text box is set to DISTRIBUTE. Try changing this to LEFT
or GENERAL.
 
anon,
Thanks for the suggestion but the Txt align property is
not the problem. I think the problem lies in format of
the field in the table. The field size is set to 50
(which is needed) but when you reference the field it
fills all of the unused characters with spaces. Currently
the field in the table is not formated and there is no
input mask associated with it.

This problem is weird because I have a similar control
that gets its contents fromt he same query and it turns
out fine. it is : = [FName] & " " & [LName]
both of these fields are also set to be 50 characters in
length but I do not have a problem with them. Any other
suggestions would be appreciated

Thanks again.
 
Back
Top