Can I have a hidden field in a report?

  • Thread starter Thread starter Charlotte
  • Start date Start date
C

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?
 
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.
 
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."
 
Charlotte said:
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?
Click to expand...


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.
 
Back
Top