To learn more about how and where you can use formatting, see the Using Formatting section.

Recordset format is used for printing records contained in a variable of the recordset type as text. Such variable can be created, for instance, with a query or, for instance, in a many-to-many relational field. This format appears as a list of fields, data from which is to be displayed. Suppose, we have the [$recs] variable that contains 3 records with the following field values:

#	Date	Title	Quantity	Total
Record 1:	2006-07-14	Apple	5	15
Record 2:	2006-07-16	Tomato	10	20
Record 2:	2006-07-19	Juice	4	16

Let's show how they will appear with different recordset formattings:

Test Text Formula	Result
[$recs^rset |Title|, ]	Juice, Tomato, Apple
[$recs^rset |Title| - $|Total|; ]	Juice - $16; Tomato - $20; Apple - $15
[$recs^rset |Date|: |Title| - $|Total|[br]] ([br] - means line BReak)	2006-07-14: Juice - $16 2006-07-14: Tomato - $20 2006-07-14: Apple - $15
[$recs^rset |Title|, Quantity=|Quantity|;[br]]	Juice, Quantity=4; Tomato, Quantity=10; Apple, Quantity=5
[$recs^rset "|Title|", "|Quantity|"[br]]"	"Juice", "4" "Tomato", "10" "Apple", "5"

Please note that in the last example there is an additional quote before the tag closure. This is necessary since the delimiter (in this case, the "[br]) is not to be placed.

Thus, the recordset format is the foundation for outputting record set values.

For performing operations over records in a recordset variable, use the cycle For Each Record From Recordset.