Can I have a hidden field in a report?

[Charlotte]

I want to use a particular field to sort my report but not have the field
showing on the report (like you can with a query). Is this possible and if
so, how do I do it?

 

[Allen Browne]

In report design view, open the Sorting And Grouping pane, and choose the
field there.

You should not have to put a hidden text box on the report in this case.

 

[StrayBullet via AccessMonster.com]

You should be able to sort by it so long as it's part of the report's source.
If not, then put it on the report and set it's visible property to No.

 

[Al Campagna]

Charlotte,
In report design view, set that control's Visible property to No.

But, a control doesn't have to physically be on the report in order to
sort by it's value.
As long as it's a legitimate field in the recordset of the report's
query, the report data will sort properly.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Marshall Barton]

I want to use a particular field to sort my report but not have the field
showing on the report (like you can with a query). Is this possible and if
so, how do I do it?

Sorting in a report is specified in the Sorting and Grouping
window (View menu). The fuield must be in the report's
record source table/query, but there is no other
requirement.

You can always bind a text box to a record source field and
set the text box's Visible property to No if you don't want
to see it.

It sounds like you are using a wizard to create the report
and have been trapped by the wizard's limitations. If so,
you should relagate the wizard to the scrap heap and get on
with designing reports using all the features of Access.