[AccessD] CrossTab Form

I have an Access XP form (from a legacy database) that is based on a 
crosstab query.  Across the top are a list of products.  Down the 
first column are a list of headings: Opening Balance, Stock In, Total 
Stock, Stock Out, Stock Out Percentage, Closing Balance etc (there 
are 25 rows in total).  The data is gathered from a number of other 
tables and queries which are linked only by the product code and are 
in different formats, and then placed in a temporary table for the 
crosstab.  The number of fields is consistent - there will always be 
the same products, and the same headings (therefore the use of a 
cross tab is not for flexibility of changing products, but to get the 
data into the required format).  There are 16 products and 25 
headings, therefore 400 fields of data.

Most of the rows are standard numbers but some are percentages.  The 
problem is that all rows are formatted the same way with no decimal 
places.  This means that the percentage rows only show whole 
percentages (the numbers are calculated so that 2.75% is stored as 
2.75 and shows as 3).  What I am looking for is a simple solution 
where I can format each row of data on the continuous form to suit 
the type of data.

The sledgehammer way is to create a table with one row and a text box 
for all 400 fields.  This would then be used on a form which is set 
out in a row format.

I suggested that the form be turned around so that the products are 
down the side and the headings across the top (in standard Access 
fashion) but this is not the format the client wants.

Is there any easy way around this?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand