hi all,
I have several option button and when I design report , they are not seen well in report, is there a way to increase size of the option button ??
hi all,
I have several option button and when I design report , they are not seen well in report, is there a way to increase size of the option button ??
Options are good for forms,but you don't really need it in a report.
just show the value.
Agree with previous comment. Set the options on the form before opening in report.
In any case, buttons on reports are only visible in report view. They do not show in print preview or when printed.
You can increase the button size in design view by dragging or typing in the values in the property sheet.
However if your report has layout guides, you may need to remove those first.
Make a copy of your report first in case it goes wrong.
I have type of Yes/No fields in table and I Changed them from check box to option button on form and report. I need option button (radio button) on report to print.
In 20 years of using Access, I've never needed an option button on any report to print it!
Why not just open the report in Print Preview instead of Report view?
hey, thank you, I was wrong, my problem is resolved. I have another question. I wrote a code on expression builder in query but it's not working :
Nz([Forms]![frm_Main]![Text281],"*")
can anyone tell me problem of this code??
It's incomplete and so is "it's not working" thus I'm going to say no. I don't expect much disagreement because what you posted looks ok.
For those that follow you in days to come, can you report what the solution was?
Thanks.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I don't recommend using * for the false part as it is used as a wildcard in Access.
But if you really must do so, then assuming that this is a control on the same form just use Nz([Text281],"*").
If its a query then the form needs to be open and would I think need to be a single form.
If so, then I think Nz(Forms!frm_Main.Text281,"*") ought to work (untested) but I would use something instead of "*"