Access 2003 forms

[Guest]

Hello,

I am working on a form in Access 2003. There is a text field that when left
blank will display a (0) on the report. Any help will be appreciated. I
don't know if it matters, but the input is a number.

Thanks

 

[babyatx13 via AccessMonster.com]

Hello,

I am working on a form in Access 2003. There is a text field that when left
blank will display a (0) on the report. Any help will be appreciated. I
don't know if it matters, but the input is a number.

Thanks

Set the default value as 0 then in VBA statement
If Field.value = 0 then
field.visible = false
else
field.visible = true
end if

K Board

 

[Guest]

I don't think I explained my situation very well. Is this what I would do to
avoid the (0) being displayed. Is this the only way to stop this (0) from
being displayed when nothing is entered. Is there a way to do it within
Access.

Thanks for the help.

 

[Guest]

Check the default property of the field in the table. Access has a nasty
habit of setting the default property of a number type field to 0 and not
telling you about it.

Also check the default property of any controls bound to this field.
Sometimes the control Default property also gets set.

HTH

 

[Guest]

Thanks for the advice Steve. I tried taking a look at the field properties;
but it didn't help. I guess I am going to have to study the VB statements in
order to fix this problem.