Unlocking Fields in Report Design

[CrzyIcE]

Hi, I have a question about how to unlock the fields that are connected together in Microsoft Access 2007 in the Report Design View form.
I tried looking everywhere in the "Arrange" Tab and I cant find the feature to unlock them so I can move each field freely.
Does anyone know how to do this?
Thanks for your time.

edit: Nevermind, I found out how to do it.

I have another question though - How do you insert new header/footers for a specific field? I ran the report wizard and it only gave me page/report footer and header and the detail.
If I add a new grouping, it only gives me the header and not the footer. How do I get the footer to show in the design view?

 

[vbaInet]

I have another question though - How do you insert new header/footers for a specific field? I ran the report wizard and it only gave me page/report footer and header and the detail.
If I add a new grouping, it only gives me the header and not the footer. How do I get the footer to show in the design view?

Welcome to AWF!

Drop the field onto your report, right-click that control and select GROUP ON.

 

[CrzyIcE]

ooh I see!
thanks!

 

[vbaInet]

You're welcome

 

[leddy]

I'm trying to find out how to unlock the fields in the report design view like the original question - can you post how you did it please?

Many thanks
leddy

Edit: ha, as soon as I posted I figured it out - you right click and go to Layout > Remove (for anyone else with the same issue )

 

[monkbiker]

When I right-click a field and then go to Layout - Remove, it deletes the field. I don't want to delete it, I want to unlock it. Any suggestions?

 

[vbaInet]

It doesn't delete anything. If you selected one of the controls in the middle or on the far left it will unlock it and re-align the other controls. So it may look as if it's hidden but it's actually behind the other controls that still have the lock on.

Select ALL the controls, right-click one of the textboxes > hit Layout > click Remove.