Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Logical field in a report

Posted on 2013-05-13
2
Medium Priority
?
397 Views
Last Modified: 2013-05-13
Just a quick question.

I'm using a Logical field in a table and a check box on the form. In the report I want the field to display "X" for .T. and nothing for .F.

Is there a simple way of doing this.

Thanks
0
Comment
Question by:davidtotty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 43

Accepted Solution

by:
pcelba earned 2000 total points
ID: 39160912
1) You have to use expression in the report field:

IIF(YourLogicalField, "X", " ")

or

2) You may just print "X" string (or any image or some Wingdings font character) and  place YourLogicalField  into "Print When" expression.
0
 

Author Closing Comment

by:davidtotty
ID: 39160926
Thanks pcelba :) that works nicely
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Read on to get a few ideas on how to promote your next corporate event.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question