G
Gulf Coast Electric
Text Box Formula in PerCent format. When there is no Data is show the above
error on form.
I need to Hide This. Thanks, Dave
=[text248]/[Text162]
error on form.
I need to Hide This. Thanks, Dave
=[text248]/[Text162]
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
#Div/0! Error on No Data, Need to Hide This if no data. Thanks, Dave
K
Kelvin
Try
=IIF([Text162]>0,[text248]/[Text162],"")
Only when Text162 is valid, the percent will be shown, otherwise it shows
nothing. This will cover when Text162 is 0 too.
Kelvin
=IIF([Text162]>0,[text248]/[Text162],"")
Only when Text162 is valid, the percent will be shown, otherwise it shows
nothing. This will cover when Text162 is 0 too.
Kelvin
J
John Viescas
Create a calculated field in the query that's the Record Source:
DivResult: IIF([Text162] = 0, Null, [text248]/[Text162])
Set the Control Source to DivResult.
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
DivResult: IIF([Text162] = 0, Null, [text248]/[Text162])
Set the Control Source to DivResult.
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
E
Emilia Maxim
Gulf Coast Electric said:Text Box Formula in PerCent format. When there is no Data is show the above
error on form.
I need to Hide This. Thanks, Dave
=[text248]/[Text162]
Try this:
=Iif(IsNull([Text162]),Null,[text248]/[Text162])
Best regards
Emilia
Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de