Percentage format lost

[Ray S.]

I have a form with an unbound text box whose row source type is this select
query:

SELECT CheckFinalPercentages.AllocType, CheckFinalPercentages.[Master-Sub],
CheckFinalPercentages.SumOfPERCOUT AS Pct FROM CheckFinalPercentages ORDER BY
CheckFinalPercentages.AllocType DESC , CheckFinalPercentages.[Master-Sub];

The query runs fine and returns the SumOfPERCOUT in percent format when I
run the query...it used to return it in percent format also on the form, but
I must have done something that made me lose it. Now, each time I open the
form, the third column is returned in number format (1 instead of 100%). Does
anybody know what I did to screw that up? I'm not sure if it's something in
the text box's properties list that I inadvertently changed.

 

[Dustin B]

Go to the unbound text box and right click. Under the format tab there
should be a field for format. Change that to percent. This could be what
was changed.