By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

text box back color on a continous form

P: 56
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.


Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2.   If IsNull(Me.txtDone) Then
  3.     Me.txtDone.BackColor = 16777215
  4.   Else
  5.     Me.txtDone.BackColor = 255
  6.   End If
  7. End Sub
Feb 8 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Continous forms have a will of their own.
Best to use the Conditional Formatting option from the Format menu.

Nic;o)
Feb 9 '07 #2

P: 56
Continous forms have a will of their own.
Best to use the Conditional Formatting option from the Format menu.

Nic;o)
it only seems to read the first line.
Feb 9 '07 #3

nico5038
Expert 2.5K+
P: 3,072
Conditional formatting will process all rows.
What are you using ?

Nic;o)
Feb 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.