Moving fields in the detail section of a report

  • Thread starter Thread starter James23
  • Start date Start date
J

James23

In design mode, I'm trying to move fields around in the detail section of the
report in the same way as I did in older versions of Access, and it's not
working the same way. It seems to want to select all the fields when I just
want to choose one, and I can only move all of them at once.

How to I move separate fields around ?
 
Here's something else DM.

When I open a report that I already had created some time ago, I can move
fields around in the design view just like I used to.

It's iin the new report that I tried to create that I select one field and
it wants to move all of them. ?????
 
this is interesting; not seen this problem yet.

I do know some of the features are laid out differently (closer) and where
you would be self trained to click in older versions, now when you are quick
to click may be too far over to the right and click the wrong thing.
however,...

can you explain the couple of steps up to where it starts dragging all the
fields instead of the one?

exmp: Open in design, find the one field, click/hold/drag, .....


Also, does this do this with all your reports or just one?
 
Here is what it does (again, it doesn't do it in a old report that I already
had in the database, just with this new one that I am trying to create.

When I click on a field in the 'detail' area, it highlights it with a dotted
line box that extends up into and around it's label in the page header.

When I try to drag the field, it drags ALL the fields in the detail area
(but they are not all highlighted ...... just the one I click on is
highlighted)
 
James23 said:
Here is what it does (again, it doesn't do it in a old report that I
already had in the database, just with this new one that I am trying
to create.

When I click on a field in the 'detail' area, it highlights it with a
dotted line box that extends up into and around it's label in the
page header.

When I try to drag the field, it drags ALL the fields in the detail
area (but they are not all highlighted ...... just the one I click on
is highlighted)
Click to expand...

It's a feature. :-)

I'm not very familiar with 07, but I have seen others posts describing what
you are talking about and it is (I believe) an option that can be turned on
and off.
 
I just looked over MS Access 2007 online and found it should be the same.
Have you done any editing to your report in VBA?


http://office.microsoft.com/en-us/access/HA012307391033.aspx
Fine-tune your report in Design view
You can also fine-tune your report's design by working in Design view. You
can add new controls and fields to the report by adding them to the design
grid. The property sheet gives you access to a large number of properties
that you can set to customize your report.

To switch to Design view, right-click the report name in the Navigation Pane
and then click Design View .

Access shows the report in Design view.

You can use the property sheet to modify the properties for the report
itself and the controls and sections it contains. To display the property
sheet, press F4.

You can use the Field List pane to add fields from the underlying table or
query to your report design. To display the Field List pane, do one of the
following:

a.. On the Format tab, in the Controls group, click Add Existing Fields.
b.. Press ALT+F8.
You can then add fields by dragging them from the Field List pane to the
report.

Top of Page

Add fields from the Field List pane
a.. To add a single field, drag the field from the Field List pane to the
section where you want it displayed on the report.
b.. To add several fields at once, hold down CTRL and click the fields
that you want. Then, drag the selected fields onto the report.
When you drop the fields onto a report section, Access creates a bound text
box control for each field and automatically places a label control beside
each field.
 
Ok, thanks DM.

I'll mess with it for a while and see if I can make it work.

Thanks again for your assistance.
 
When you are in design view, just highlight the controls, got to the
"Arrange" tab
and click "Remove" (fourth button from the left).
 
BINGO.

Thanks Peter.

Beetle said "When you are in design view, just highlight the controls, got
to the
"Arrange" tab
and click "Remove" (fourth button from the left).

........ which seems to be the same thing.

Thanks guys. Big help.

--
 
Back
Top