Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 126
  • Last Modified:

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.
0
SteveL13
Asked:
SteveL13
  • 4
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try


=IIf(IsNull([txtSchedLBHR]),Null,[txtTotalWeight]/[txtConvertedSchedHrs])
0
 
SteveL13Author Commented:
Didn't work.  Sorry.
0
 
Rey Obrero (Capricorn1)Commented:
how about

=IIf([txtSchedLBHR] >0,[txtTotalWeight]/[txtConvertedSchedHrs],0)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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
 
Rey Obrero (Capricorn1)Commented:
test this
Test-DB.zip
0
 
SteveL13Author Commented:
Perfect.  Thank you.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now