I am trying to build a radio group from a SQL query. For the display, I want to show different information. However, when it displays on teh screen it is all in one line. I was hoping to be able to display it on separate lines. I have tried to concatenate the query with chr(13) and chr(10), but it does not display correctly.
With the example I'm working with, the SQL query returns two records (which means two radio options). I am concatenating several fields together for the display. I would like for the radio group to look like so…
Radio 1
Name
Street
Class
Radio 2
Name
Street
Class
The radio options look like so right now…
Radio 1
Name Street Class
Radio 2
Name Street Class
Is what I'm trying to do possible? If so, does anyone know how to accomplish it?