Continuous Forms text box if null then disable

[June7]

It's no rumor! I set up a form with 7 (+default) conditionals. I understand the limit is 50.

Sorry shree, I don't understand description of your issue with the code.

[shree]

hi June, my issue is simple if our Bal value is "0" then for that Detail should not be appear in form note if bal filed value is "0"

[June7]

The suggested code should work. Use the name of the textbox.

Me.textboxname.Visible = Nz(Me.textboxname) <> 0

Unless you want to provide the project for analysis, don't know what else I can offer.

[shree]

Hi JUNE, For your VBA code i have used in on current but "me.Bal.value there is no argument for visible after . there is only value is showing

instead of bal i took text25 its working but both detail texts are disappear even one has BNP has position (value)

For your VBA code i have above issue

[June7]

Already stated I don't understand the description of issue. How can 'both detail texts are disappear' when the code addresses only one control and what is 'BNP'? We are going in circles. If you want more help I will have to review project to analyse your effort.

[Missinglinq]

You cannot use code for this because Form3 is a Continuous View Form! It has to be done with Conditional Formatting off of the ribbon.

In Form Design View

• Press and Hold down the <Shift> key
• Click to select the two Controls to be formatted
• On the ribbon, under Database Tools, click on Conditional Icon
• Under Condition1, with the dropdown, select Expression Is
• In the next box enter [BAL] = 0
• Click on the Enable/Disable Icon (last one on the right, beyond the big A Fore Color Icon)
• Click on OK

You should now be set. I assume that this Form is for Display Only, as it is based on a Read-Only Query.

Linq ;0)>

[June7]

Ooops! Good point, Missinglinq. Should have caught that from the very first thread.

Also, even in Single View, the control is still there and occupies space. Depending on arrangement of controls, could appear as a blank area between other controls.

Regardless of form view, the conditional formatting can only disable/enable the control, it will remain visible.