By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,553 Members | 1,128 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,553 IT Pros & Developers. It's quick & easy.

Display Y/N on report instead of -1/0

P: 274
l have some logical enteries in my form (Y/N)
When I print my DataReport it says -1 for true and 0 for false. I want to display Y and N resp.
Can some tell me what I should do.
I have been something like this but no luck it display either Y or N for all entries rest of the entries are ok

Expand|Select|Wrap|Line Numbers
  1. If ctl.Name = "txtpay_GST" Then
  2.                If oRS.Fields(5) = True Then
  3.                 ctl.Caption = "Y"
  4.                 Else
  5.                 ctl.Caption = "N"
  6.                 End If
  7.              End If
Thanks in advance
Dec 7 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 5K+
P: 8,127
You need to use DECODE in the SQL statment for the formatting.
Dec 7 '07 #2

P: 180

select the text control in DataReport. open properties window.
double click on the DataFormat property. in the Property Pages select 'Custom' format type. in the 'Format String' text box type #;Y;N
this will solve the problam

manpreet singh dhillon hoshiarpur
Dec 8 '07 #3

P: 274
Thanks Manpreet
Your tips really worked great. Thanks again.
Dec 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.