Display field when > 0

[jervin via AccessMonster.com]

Good day,
i need to display my form only if one field value is more than 0(zero).

Example if i had a field name "onhand" and i want the form to display only if
field onhand is more than zero..

thanks again....

 

[Tom Lake]

Good day,
i need to display my form only if one field value is more than 0(zero).

Example if i had a field name "onhand" and i want the form to display only
if
field onhand is more than zero..

thanks again....

Create a control on the form and call it onhand.

Make the Control Source be the field onhand from your table.

In the On Open event for the form put this code:

If [onhand] > 0 Then
Me![onhand].Visible = True
Else
Me![onhand].Visible = False
End If

Tom Lake

 

[jervin via AccessMonster.com]

im sorry sir i dont know how to create a control...im just started using ms
access...can you guide me pls...thank again

Good day,
i need to display my form only if one field value is more than 0(zero).

[quoted text clipped - 4 lines]

thanks again....

Create a control on the form and call it onhand.

Make the Control Source be the field onhand from your table.

In the On Open event for the form put this code:

If [onhand] > 0 Then
Me![onhand].Visible = True
Else
Me![onhand].Visible = False
End If

Tom Lake

 

[Larry Linson]

Unless you have done something to prevent it or hide it, there will be a
"Toolbox" bar alongside the Form in Design View. You can hover your mouse
pointer over the icons to see a ToolTip that tells you what they are. The
one you want is a Text Box... click the icon, then move the mouse pointer to
the place on the form that you want a Text Box, and click. Then you can use
the Property Sheet for that Text Box to change the properties to what you
want.

Larry Linson
Microsoft Access MVP

im sorry sir i dont know how to create a control...im just started using
ms
access...can you guide me pls...thank again

Good day,
i need to display my form only if one field value is more than 0(zero).

[quoted text clipped - 4 lines]

thanks again....

Create a control on the form and call it onhand.

Make the Control Source be the field onhand from your table.

In the On Open event for the form put this code:

If [onhand] > 0 Then
Me![onhand].Visible = True
Else
Me![onhand].Visible = False
End If

Tom Lake

 

[jervin via AccessMonster.com]

thanks....

Unless you have done something to prevent it or hide it, there will be a
"Toolbox" bar alongside the Form in Design View. You can hover your mouse
pointer over the icons to see a ToolTip that tells you what they are. The
one you want is a Text Box... click the icon, then move the mouse pointer to
the place on the form that you want a Text Box, and click. Then you can use
the Property Sheet for that Text Box to change the properties to what you
want.

Larry Linson
Microsoft Access MVP

im sorry sir i dont know how to create a control...im just started using
ms

[quoted text clipped - 19 lines]