Hi,
I'm having a weird format problem.
I have a text box on a form that I use to display a number from a subform.
I use it because its on another tab of the form.
It works fine but the format only works under one condition.
The control source is:
=[Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered] & " Yds"
and its working fine but i noticed it didnt have a comma if it was a number in the thousands so i set the format to Standard and decimal places zero.
ex. it displays 30000 Yds but i want it to display 30,000 Yds
Basically Access ignores the format conditions i set unless i remove the end portion of the control source ....... & " Yds"
If i make the control source:
=[Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered]
then the format works.
Is there a way around this or is this a bug in access?
Thanks for any input.
Brian
I'm having a weird format problem.
I have a text box on a form that I use to display a number from a subform.
I use it because its on another tab of the form.
It works fine but the format only works under one condition.
The control source is:
=[Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered] & " Yds"
and its working fine but i noticed it didnt have a comma if it was a number in the thousands so i set the format to Standard and decimal places zero.
ex. it displays 30000 Yds but i want it to display 30,000 Yds
Basically Access ignores the format conditions i set unless i remove the end portion of the control source ....... & " Yds"
If i make the control source:
=[Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered]
then the format works.
Is there a way around this or is this a bug in access?
Thanks for any input.
Brian