|
|
|
#1
06-23-2009, 11:22 AM
|
|||
|
|||
Color/font change in subform
Is it possible to change forecolor or backcolor of a field on a subform? Changing them in a form was no problem. Here is teh code I used.
Select Case Me.txtColorCntl.Value Case 1 Me.[Form - Child].Form.Points.BackColor = 65535 Me.[Form - Child].Form.Points.FontSize = 14 Me.txtColorCntl.BackColor = 65535 Me.txtColorCntl.FontSize = 14 Case 2 Case 3 Case 4 End Select Me.[Form - Child].Requery 
|
|
#2
06-23-2009, 12:04 PM
|
||||
|
||||
|
The answer is yes but the syntax is different.
http://www.mvps.org/access/forms/frm0031.htm
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#3
06-24-2009, 03:41 AM
|
|||
|
|||
|
backcolor and fontsize property still not working
Hello,
Thanks for the syntax. When I tried the following, Locked property works, but backcolor and fontsize don't work. Values of the properties are changed, but no affect to the form. Select Case Me.txtColorCntl.Value Case 1 Me![Form - Child].Form!Points.Locked = True Me![Form - Child].Form!Points.BackColor = 65535 Me![Form - Child].Form!Points.FontSize = 14 Case 2 Case 3 Case 4 End Select Me.[Form - Child].Requery
|
|
#4
06-24-2009, 05:11 AM
|
||||
|
||||
|
Maybe Me![Form - Child].Form.Repaint will do it.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#6
06-24-2009, 07:07 AM
|
||||
|
||||
|
How about posting a sample db so we can play with it?
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#8
06-24-2009, 08:10 AM
|
||||
|
||||
|
You are probably dealing with a limitation of the Datasheet view which I do not use. Here it is in Continuous Form mode. Try 1 and 2 as Color Codes.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#10
06-24-2009, 02:34 PM
|
||||
|
||||
|
Glad I could help.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I change the color of a text label with a mouse movement? | Deanamay | Access | 1 | 03-29-2009 06:27 AM |
| Change Color of a Command Button when Receives Focus? | skyrise | Forms | 2 | 03-10-2009 03:14 PM |
| change cell color | bishop743 | Programming | 0 | 02-01-2009 08:00 AM |
| Changing font color based on criteria | Pattie Weaver | Reports | 3 | 03-27-2006 12:25 PM |
| font of word bookmarks | emilylu3 | Programming | 1 | 03-09-2006 09:07 AM |
Color/font change in subform
Windows 98/ME 
Access 2003 (version 11.0)
Linear Mode
