Formatting a report based on checkboxes

[Amit]

Access 2K, Windows XP
=====================
Hi,

I have to format a report and am having problem
conceptualizing it. The table has checkbox fields for each
language (eg. English, French, Spanish, Portuguese,
Russian, Haitian-Creole, Chinese, Cape Verdean) offered by
an organization. The organization can offer 0 or more
languages, and the correspondign language checkbox is
checked if the language is offered. I have to display the
name of the languages offered by the organization.

So, if an organization offers English and French (checkbox
for English and French is checked), I need to display on
the report: 'English, French' and if it offers French and
Portuguese, then display: 'French, Portuguese', and so on.

This will involve shrinking of controls. I'm not sure how
to approach this so that it'll work for all combinations
of languages being offered. Do I need to have separate sub-
forms, one for each language, and then include them in the
main report?

Thanks for any help or pointers.

-Amit

 

[Fons Ponsioen]

What about and unbound textbox with the following formula:
IIf([ChkEng],"English","") & IIf([ChkEng] And [ChkFre],",
Frech","") & IIf([ChkSpa],", Spanish","") & IIf
([ChkPor],", Portuguese","") & IIf([ChkRus],",
Russian","") & IIf([ChkHai],", Haitian-Creole","") & IIf
([ChkChi],", Chinese","") & IIf([ChkCap],", Cape
Verdean","")
Where ChkEng is used for the English checkbox etc. for all
The textbox should be long enought to accomodate the total
string length.
Hope this helps.
Fons

 

[Amit]

-----Original Message-----

What about and unbound textbox with the following formula:
IIf([ChkEng],"English","") & IIf([ChkEng] And [ChkFre],",
Frech","") & IIf([ChkSpa],", Spanish","") & IIf
([ChkPor],", Portuguese","") & IIf([ChkRus],",
Russian","") & IIf([ChkHai],", Haitian-Creole","") & IIf
([ChkChi],", Chinese","") & IIf([ChkCap],", Cape
Verdean","")
Where ChkEng is used for the English checkbox etc. for all
The textbox should be long enought to accomodate the total
string length.
Hope this helps.
Fons

Thanks for the response, but that didn't work
Also, I need to insert a comma if there are more than 2
languages.

-Amit

 

[Fons Ponsioen]

What is it that did "not work"
I did forget to tell you to type in an "=" (without the
quotes) before the first IIF.
I did include the "," the way I did it was I assumed you
would have at least English or French, and after that each
language would be added with its own comma.
Let me know what you find.
Fons

-----Original Message-----

-----Original Message-----
What about and unbound textbox with the following formula:
IIf([ChkEng],"English","") & IIf([ChkEng] And [ChkFre],",
Frech","") & IIf([ChkSpa],", Spanish","") & IIf
([ChkPor],", Portuguese","") & IIf([ChkRus],",
Russian","") & IIf([ChkHai],", Haitian-Creole","") & IIf
([ChkChi],", Chinese","") & IIf([ChkCap],", Cape
Verdean","")
Where ChkEng is used for the English checkbox etc. for all
The textbox should be long enought to accomodate the total
string length.
Hope this helps.
Fons

Thanks for the response, but that didn't work
Also, I need to insert a comma if there are more than 2
languages.

-Amit

.

.

 

[Amit]

Duh. It worked. I was putting it in the "Format" section
instead of "Control Source", and that's why it didn't work.

Thanks!

-Amit

-----Original Message-----

-----Original Message-----
What about and unbound textbox with the following formula:
IIf([ChkEng],"English","") & IIf([ChkEng] And [ChkFre],",
Frech","") & IIf([ChkSpa],", Spanish","") & IIf
([ChkPor],", Portuguese","") & IIf([ChkRus],",
Russian","") & IIf([ChkHai],", Haitian-Creole","") & IIf
([ChkChi],", Chinese","") & IIf([ChkCap],", Cape
Verdean","")
Where ChkEng is used for the English checkbox etc. for all
The textbox should be long enought to accomodate the total
string length.
Hope this helps.
Fons

Thanks for the response, but that didn't work
Also, I need to insert a comma if there are more than 2
languages.

-Amit

.

.