Add spaces to the left of text in Combo Boxes on report

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hello,
I used the report wizard to add fields to my report including several that
were originally combo boxes on a form. The text that appears in the combo
box on the report is right up against the left most line of the combo box
making the first letter hard to read. I want to add some space between the
left most line and the text. For text boxes on a report, I would go to
format => Left and add .05". However, this is simply moving the entire box
to the right rather than the text within the box. Can someone help?

Thanks,
 
Open the report in design view, right click, scroll down and select
properties.
Click on the text box. Click in the Control Source and add brackets to what
is there now like this -- [Some_Name] and then move cursor the the
beginning and type in " " & so it then looks like -- " " &
[Some_Name] and save.
 
Open the report in design view, right click, scroll down and select
properties.
Click on the text box. Click in the Control Source and add brackets to what
is there now like this -- [Some_Name] and then move cursor the the
beginning and type in " " & so it then looks like -- " " &
[Some_Name] and save.
 
Chuck said:
I used the report wizard to add fields to my report including several that
were originally combo boxes on a form. The text that appears in the combo
box on the report is right up against the left most line of the combo box
making the first letter hard to read. I want to add some space between the
left most line and the text. For text boxes on a report, I would go to
format => Left and add .05". However, this is simply moving the entire box
to the right rather than the text within the box.
Click to expand...


Try setting the text box's LeftMargin property to .05

If your version of Access is too old to have that property,
maybe you can live with using a text box expression like:
=" " & thefield
 
Chuck said:
I used the report wizard to add fields to my report including several that
were originally combo boxes on a form. The text that appears in the combo
box on the report is right up against the left most line of the combo box
making the first letter hard to read. I want to add some space between the
left most line and the text. For text boxes on a report, I would go to
format => Left and add .05". However, this is simply moving the entire box
to the right rather than the text within the box.
Click to expand...


Try setting the text box's LeftMargin property to .05

If your version of Access is too old to have that property,
maybe you can live with using a text box expression like:
=" " & thefield
 
i'd suggest getting rid of the combobox controls. instead, write a query
that includes the tables used as RowSource in those combobox controls, and
put the "text" fields you need to see into the query output. use the query
as the RecordSource of the report.

hth
 
i'd suggest getting rid of the combobox controls. instead, write a query
that includes the tables used as RowSource in those combobox controls, and
put the "text" fields you need to see into the query output. use the query
as the RecordSource of the report.

hth
 
Back
Top