Populate a combo box

[Debbiedo]

I am working in Access 2003

I have a combo box with two columns. It is bound to a yes/no field
called "Accept". The forms displays the word "Accepted " in the second
column in the combo box) but records -1 or Yes to the "Accept" field.

How do I get the report to show the words "Si" or "Accepted" (english
and spanish- I will be using two boxes for this) on the report based
on what is entered on the form and subseqently the table (the form
does a refresh upon opening of the report)

Thanks in advance

Deb

 

[Allen Browne]

Place a text box on the report, with its Control Source something like this:
=IIf([Accept], "Si or Accepted", Null)

 

[John Spencer]

Or use the format property of the control showing -1 or 0 or null

Format: " " ;"Accepted";" ";" "

After you leave the property, you will probably see the quote marks
disappear around the spaces
Format: ;"Accepted"; ;
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Place a text box on the report, with its Control Source something like
this:
=IIf([Accept], "Si or Accepted", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am working in Access 2003

I have a combo box with two columns. It is bound to a yes/no field
called "Accept". The forms displays the word "Accepted " in the second
column in the combo box) but records -1 or Yes to the "Accept" field.

How do I get the report to show the words "Si" or "Accepted" (english
and spanish- I will be using two boxes for this) on the report based
on what is entered on the form and subseqently the table (the form
does a refresh upon opening of the report)

Thanks in advance

Deb