If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How To Change BackColor of a Box
(Using Access 2003) I would like to change the back colour of a box,
depending on the result of a calculation. In a previous db many years ago, I was told I could achieve this by going into the "Details" - "On Format" with the following Event Procedure Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Text36 = "Yes" Then Box35.BackColor = vbGreen ElseIf Text36 = "No" Then Box35.BackColor = vbRed ElseIf Text36 = "on" Then Box35.BackColor = vbBlue Else: Box35.Back Color = vbWhite End If End Sub Whilst this worked perfectly for Acces 98, however this nolonger seems to work with Access 2003, is there another way to achieve this please Bob |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I Change recurrence settings with OUT updating details???? | Shawn Anderson | Calendar | 3 | September 20th, 2004 06:38 PM |
How can I Change recurrence settings with OUT updating details???? | Shawn Anderson | General Discussion | 3 | September 20th, 2004 06:38 PM |
change regional Settings To UK currency format from a shared hosting server in Germany... | Edward | General Discussion | 1 | September 19th, 2004 11:36 AM |
How do I change data in one cell so other copies& vice versa | sedain | New Users | 3 | September 8th, 2004 10:07 PM |
Writing a macro to change external links to manual updating in Excel 2000 | John Wirt | Links and Linking | 5 | February 16th, 2004 08:03 AM |