Changing from # to text on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a report that presents data that is taken from a value field. In other words, 0 = Schools and 1 = Private. When the report opens - it shows the number, and I want to show the actual text. How can I change this when the report is opened

Thanks

Eric
 
I would have a separate table called something like "refSchoolTypes",
meaning it is a reference (lookup) table for the schools. It would have a
primary key holding the number and a text field holding the type of school.
Then in the query behind the report, I'd join the refSchoolTypes table to
the main table and make the SchoolText field the control source for the
control.


--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Eric Chajmovic said:
Hello,

I have a report that presents data that is taken from a value field. In
Click to expand...
other words, 0 = Schools and 1 = Private. When the report opens - it shows
the number, and I want to show the actual text. How can I change this when
the report is opened?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line drawing on report 0
Cross Tab Report Vs Dynamic coulmns 0
Filtering subreports on main report 0
Can't create a report from my query in Access 1
Access Access Report Works on One Machine but not Another 3
Change text box background color depending on value in Label Reports 1
sub report text field not visible in main report 8
Cross tab vs. report 1

Back
Top