Change label color when the field is not null

[kiri19]

I would like to change the Background color of the label to Red when Notes is not empty in the table, this is when a combobox autopopulate the fields in the form.
The Notes textfield opens when the label is clicked on, this works, but the Background color of the label does not turn Red when there is a note.

Private Sub Form_Current()
Notes.Visible = False
If IsNull(Me.Notes.Value) = True Then
Me.notelabel.BackColor = vbWhite
Else
Me.notelabel.BackColor = vbRed
End If
End Sub


Private Sub notelabel_Click()
Notes.Visible = True
End Sub

[Missinglinq]

By default, the Back Style Property of a Label is set to Transparent. Right-Click on the Label and Click on Properties. Now Click on the Format Tab and set the Back Style Property to Normal and your code should work.

Linq ;0)>

[kiri19]

Thanks, looks like i need to get ms access books to read, there are a lot of things i dont know

[Missinglinq]

Unfortunately, the PR department in Redmond has hawked the idea for years that MS Access is so easy to use that anyone can develop a Database! This is probably true, if you want to run up a Database to keep track of your Christmas card recipients, or a membership db for the local PTA, but not for any serious app! It is especially unfortunate because the 'suits' in companies read it and assume that it is true! They ask someone, usually a junior member of the firm, if they have any experience or if they've taken any classes in Access, and they respond with a 'yes.' Then they request a Database that would take an experienced developer a month to complete!

Yes, get a book, watch some videos, several times, and scour the internet!

Here's some sites, listed from the easiest to understand to the more difficult, that go into the nuts and bolts of development, after you get a handle of table design.

Chrystal has an excellent “basics” tutorial:

http://www.accessmvp.com/strive4peace

This is a little more advanced, but still a great starting point, having 28 well written, well defined, clearly named chapters.
:
http://www.functionx.com/vbaccess/index.htm

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

MVP Allen Browne's extensive list of tutorials and on-line reference materials:
http://allenbrowne.com/links.html#Tutorials

And the first thing to do is to learn the ABCs, literally! Learn the names of the Objects! What a Form is, what a Field is, what a Control is, and the difference between the last two.

One of the biggest problems we face, here, and on other Access forums, are newbies who can't ask an intelligent question simply because they don't know the proper words to use!

And continue to ask questions, as you've done, here!

Good luck with your project!

Linq ;0)>

[kiri19]

Thanks for the links

[Missinglinq]

Glad we could help with your problem, and always happy to help anyone who wants to learn!

Linq ;0)>