Hide #Type! in a field on a datasheet view form

I have a form opening in datasheet view.  And there is a record at the bottom of the other records that isn't really there yet.  But in one of the fields of that record I see #Type! and want to hide it.  The field's control source is:

=[txtTotalWeight]/[txtConvertedSchedHrs]

I tried this but it doesn't work:

=IIf(IsNull([txtSchedLBHR]),"",[txtTotalWeight]/[txtConvertedSchedHrs])

also tried:

=IIf([txtSchedLBHR]= "","",[txtTotalWeight]/[txtConvertedSchedHrs])

with no luck.
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this
Test-DB.zip
0
 
Rey Obrero (Capricorn1)Commented:
try


=IIf(IsNull([txtSchedLBHR]),Null,[txtTotalWeight]/[txtConvertedSchedHrs])
0
 
SteveL13Author Commented:
Didn't work.  Sorry.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Rey Obrero (Capricorn1)Commented:
how about

=IIf([txtSchedLBHR] >0,[txtTotalWeight]/[txtConvertedSchedHrs],0)
0
 
SteveL13Author Commented:
Still didn't work.

I'm going to strip most everything out of a copy of the d/b and attach it.
0
 
SteveL13Author Commented:
Attached.  A stripped down copy of the database.  

Open frmLoadingSchedule.

Need to hide the #Type! values in the record that isn't really there yet (last 3 columns).
Test-DB.zip
0
 
SteveL13Author Commented:
Perfect.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.