Solved

Logical field in a report

Posted on 2013-05-13
2
385 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
2 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 500 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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…
Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now