#Name? Error coming after field calculation

[aparnawangu]

Hi Team,
I have a form containing two columns named strength and Capacity and i have a third column named Conversion RFation which will calculate the percentage for Capacity utilization and the formula i have put there is:
[Strength]/[Capacity]*100
but above formula showing #Name? error.Pls guide me how to resolve this error.


Thanks
Aparna

 

[arnelgp]

have you set the Control Source property to:

=FormatPercent([Strenght]/[Capacity])

 

[JHB]

If both the field names and the controls have the same name, then rename the controls.