Database field cell alignment

[scubadunc]

Hi gurus



I have a database field pulling in data from an access table. It all works perfectly other than that I would like to right align "subscription.Price", leaving all the other fields left aligned. I already have formatting applied to that field, so wondering if it is a possibility to apply alignment formatting at the same time? See code below...


DATABASE \d "C:\\database\\test.mdb" \c "DSN=MS Access Database; DBQ= C:\\database\\test.mdb;FIL=MS Access" \s " SELECT subscription.PDescription, subscription.PType, subscription.SReserve, subscription.SSection, subscription.SRow, subscription.SNumber, Format(subscription.Price, '$0.00')
FROM subscription
WHERE (((subscription.ConstID)='5444'))"\l"0" \b"124"

Also, is there any way to enforce the outputted table width to the full width of the page margins?

Any help or thoughts appreciated...