Showing Case States in Forms?

[bdragoo]

So, we have this form we give to clients to have them fill out information. The form is printed from an sql-based application software. My question is: is it possible to show all of the options as it prints out? Rather than just getting the THEN "answer", is there a way to show all of the available When/Then statements? We'd like to do this so the clients know all of their available options.

Marital Status: &SQLTRIM&SQLNOCR&{SELECT MARRIAGE = CASE MARITAL
WHEN 'M' THEN 'Married'
WHEN 'D' THEN 'Divorced'
WHEN 'X' THEN 'Separated'
WHEN 'W' THEN 'Widowed'
WHEN 'S' THEN 'Single'
WHEN 'U' THEN 'Unknown'


If anyone can help with this.....many, many thanks

 

[mrdenny]

You'd want to post this in the forum related to the front end.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)