flash pro code to change selected text color of textbox

Missinglinq - now that looks great, so I've just downloaded the 3 sample db's. etc) I haven't actually tried the code yet though, so will check it out anyway & let you know, thank you! (So, for e.g., FirstName, LastName, & Suburb for one record need to be blue, while FirstName, LastName, & Suburb for another record may be green. (but thanks anyway!)ĪDezii - thanks again for your help, but I think (looking at the 1st code) that will only change all LastName fields in all records to one colour (?), while I need to change all fields of one record to one colour, & all fields of another record to a different colour. Unless I'm missing something, I don't think that's gonna work for what I need. was able to add a button to the form, but not able to add event code to it. or maybe tomorrow night, but will post back with the results.ĭenburt - yes, I thought (after previous suggestions) that a report must be the way, however when I tried that, I couldn't actually add a button to do something with a particular record (want to have 'View Details' buttons for each record, or something similar). Hey wow, thanks so much everyone! I won't get to try this till Tuesday. Let me know if this is what you are looking for: After further investigation, there is a method by which you can change the Background Color of either 'ALL' or 'SPECIFIC' Text Boxes on a Continuous Form for 'ALL' Records. You can do what you request in the OnCurrent() Event of the Form but only for the Current Record. So there are 2 kinda separate ideas there, neither right, & I really don't know if I'm even on the right track. ' How do I just loop through the controls in 1 record? ' the whole form to lngColour! (permanently, for some weird reason?!) ' following doesn't work either - it changes all textboxes on LngColour = DLookup('', 'Assessors', '='' & rs.Fields('AssessorName').Value & ''')įld.Properties('BackColor').Value = lngColor

If Not IsNull(rs.Fields('AssessorName')) Then Here's what I've got at the moment (but I keep changing it, so this is kinda muddled): (I am very foggy on whether I should be using a Recordset or directly working with the controls on the form.?) I've been messing around trying to do this with Recordset clones, then trying Me.Controls instead.

What I'm trying to do is loop through the records of the continuous form, get the colour value for the Assessor for that record, & then change the background colour of all textboxes in that record to that colour. I've got a continuous form which has 6 textboxes in each row, one of which contains the name of an Assessor, who (in another table) will have a particular colour assigned for him/her. hoping someone may be able to help me here. I've been searching the net & the forums here over the last few days for help with my problem & am getting myself really confused.

Flash pro code to change selected text color of textbox