Display empty instead of 0

Hot Topic

Recursive version builds
HTML Editor Context Menu
Broken Help Project!
ANN: Updated Chess for Feb CTP
Stopping a TextBox resizing to infinity and beyond
Clipping with binding
How do I: Add an encryption step?
Outlook blocked my script help
How to show a calender in xaml
Visual source safe internet service on port other than 80

Visual Studio

Close word Document VSTO 2005
Shaped Avalon application with full alpha-transparency
Assembly could not be found or loaded using the 2.0 Framework
Issues with VSTO 2005
Deployed RTD does not function at all
Binding error messages on LayoutTransform
Checkout "Operation timed out" error
searching text
Error on Visual Studio Tools for Office "v3" install
DataTrigger.EnterActions

Display empty instead of 0

I use an expression in a TextBox:

Fields!myField.Value/10

myField is a type of integer in SqlServer.
If the value in myField is null, the expression "myField.Value/10" will display 0,

I want  the expression to display empty if myField is null.

How can I do that

Answer this question

Display empty instead of 0

  • theflu

    You can also take advantage of the IsNothing() function.

  • SW Skeen

    try this:

    =iif(Fields!myField.Value/10=0, "", Fields!myField.Value/10).

    Good Luck.

    Long
  • Display empty instead of 0
Answer this question