Option group & Reports

[jeremy0028]

Database is almost complete put dont know how to do the following

Newbie

I have a option group called is there another insurance
in this option group has yes no none in the description field of the table 1=y 2=n 3=none

When i generate a report is display as 1 2 3 if one of the option is chosen.

Is there anyway that when a report is generated it will show as an x instead of numbers

If either yes or no is chosen can i change the spacing to match the form i have.

Also if user selects none it will show nothing in the report any ideas.

 

[sdk]

Hi,

I would have a reference table, that maps the values to various descriptions. In the report source the query would include the reference table (with descriptions), with the report itself including the description.

In your main table, I would set the default value for the source to a flag value, eg -1. This value can be included in the reference table to flag an unset value.

You could also use dlookup(...) in the text control source of the report, or use your own code to retrieve the value (eg yourCode(optValue) as string), but I think the reference table + query is the easiest and most flexible.

Cheers

Steve








Except for the last requirement, I would have said use a reference table, through either dlookup(...) or with the report source in a query