#Div/0! Error on No Data, Need to Hide This if no data. Thanks, Dave

[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]

 

[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

 

[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

 

[Emilia Maxim]

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