text box in a continous form

  • Thread starter Thread starter lilbit27
  • Start date Start date
L

lilbit27

Can I have a text box on a continous form called txty9 and say where
the value is null make the backcolor = 16777215 esle make it 255.

I put this but the color stays white even when a item is enter in that
field for a particular line.

So now I have 2 lines that have a value in txty9 but 11 are null. So 2
should be read and 11 should show white.


Private Sub Form_Load()
If IsNull(Me.txtDone) Then
Me.txtDone.BackColor = 16777215
Else
Me.txtDone.BackColor = 255
End If
 
I have a similar problem , it seems the continuous form is aware only about
the first record (!!) (see subject: "aggiornamento form ricalcolata" in this
newsgroup ).
mm
 
You'll need to use Conditional Formatting.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)









- Show quoted text -
Click to expand...

the conditioning format is not working
 
Back
Top