how to code specifically for a cell in a table

[campbell707]

Hi,



I am looking to create a box on a form that will change color based on whether or not a cell has been filled on the table. I am using this as a visual validation on the form so people can tell whether they have entered the data without going to the table.

I was thinking of using IF then else statement but I am not quite sure how to call the cell on the table.

Thinking like...

Private Sub Form_Current()

If IsNull(ActiveSheet.Range("F1").Value) = True Then
Textbox1.BackColor = vbWhite
Else
Textbox1.BackColor = vbRed
End If

End Sub


But it seems to cause a bug when viewing the form. Any thoughts?

Thanks!

[ssanfu]

It sounds like these are Excel questions. This is an Access forum.

Access does not have "cells". A datasheet looks like a spreadsheet, but Access and Excel are two totally different animals.

Care to elaborate more about your question?

[campbell707]

Thanks for responding!

I am trying to come up with a way for a person to see if there are still cells in a table that are empty but from a form page. I have 4 fields for them to enter a value for but 17 rows to fill. I have a listbox on the form so they can go from row entry to another but its all in the same form. I am hoping there is a way I could code a box to highlight a different color based on whether there is still cells that are empty.

Thanks

[ssanfu]

I would use conditional formatting. No code necessary.

You would have to apply conditional formatting to each of the 4 controls for which you want the color to change.


-------------------------------------
Tables have fields.
Forms have controls.