[RESOLVED] How to display checkbox on CR8.5

Printable View

Jul 31st, 2006, 02:35 AM
girl81

[RESOLVED] How to display checkbox on CR8.5

Hi all I have one question here.i use VB6,Access and CR 8.5
Is there any way to display [ ]checkbox in Crystal Report? It will display whether the checkbox is tick or not. If there is a way please let me know.

Thanks in advance
Jul 31st, 2006, 03:04 AM
shakti5385

Re: How to display checkbox on CR8.5

why u want to do this type of thing
Jul 31st, 2006, 04:11 AM
girl81

Re: How to display checkbox on CR8.5

Thanks Shakti..

i want to make a Fax form.I want to display a checkbox like in Access.So that it will displayed many checkbox to show that it is checked or unchecked.
Such as:

[ ]Urgent [ ]Comment [ ] Please Reply

Any idea or suggestion?
Jul 31st, 2006, 04:24 AM
girl81

Re: How to display checkbox on CR8.5

Is it possible to do like what i want to do??
Jul 31st, 2006, 04:28 AM
shakti5385

Re: How to display checkbox on CR8.5

just i am checking wait.... it is not done by me so please wait
Jul 31st, 2006, 04:32 AM
girl81

Re: How to display checkbox on CR8.5

Ok..thanks :)
Jul 31st, 2006, 04:34 AM
shakti5385

Re: How to display checkbox on CR8.5

in my idea make a booleian function and return true false condition according to the situation...
Jul 31st, 2006, 04:42 AM
girl81

Re: How to display checkbox on CR8.5

Quote:

Originally Posted by shakti5385

in my idea make a booleian function and return true false condition according to the situation...

Yes..but i dont want to do like that..it will displayed

[Y] Urgent [N] Comment [Y] Please Comment

Do you have any idea..
because i just want to know is it possible or not to display like what i want...
Jul 31st, 2006, 05:14 AM
shakti5385

Re: How to display checkbox on CR8.5

Quote:

[Y] Urgent [N] Comment [Y] Please Comment

what is
Jul 31st, 2006, 11:51 AM
brucevde

Re: How to display checkbox on CR8.5

Create a Formula field, set its Font to Wingdings and use this code (assuming your field is a yes/no field).

If {Your Table Name.Your Field Name} Then Chr(254) Else Chr(168)
Or
If {Your Table Name.Your Field Name} Then "þ" Else "¨"

Symbolic fonts such as Wingdings will display pictures instead of letters and numbers. All you need to know is which character to use. The Character Map (Start->Programs->Accessories->System Tools) will show you that information.
Jul 31st, 2006, 12:15 PM
girl81

Re: How to display checkbox on CR8.5

Quote:

Originally Posted by brucevde

Create a Formula field, set its Font to Wingdings and use this code (assuming your field is a yes/no field).

If {Your Table Name.Your Field Name} Then Chr(254) Else Chr(168)
Or
If {Your Table Name.Your Field Name} Then "þ" Else "¨"

Symbolic fonts such as Wingdings will display pictures instead of letters and numbers. All you need to know is which character to use. The Character Map (Start->Programs->Accessories->System Tools) will show you that information.

:eek: U are great Brucevde...i got it..i dont know what to say..u are my hero.. :)
i'm so wonder how you can do that..

thanks a lot...