I have a bunch of checkboxes on a tab (The tab is on a subform) that uses fileExists( ) on form entry to change the color of the box and add a mark as a visual indicator if the file exists or not. The problem I am having is that the colors do not update on form entry unless I place my curser in the tab itself (In XP) or over each box (In 98Se). I believe the on form entry is firing properly because the if fileExists(V1003YN) YN1003 = 1 part of the statement works perfectly so I think I am using Forceredraw( ) incorrectly.
I have tried placing the Forceredraw ( ) at the end of my entire statement and as shown in my example below at each use of RGBColor and neither approach solves the problem.
Were is the correct place for me to use Forceredraw( )? Is there something else I need to do?
Thanks
iF FileExists(V1003YN) { YN1003 = 1 RGBColor(YN1003,-1,-1,-1,0,255,0) Forceredraw() } else { YN1003 = 0 //RGBColor(YN1003,-1,-1,-1,255,0,0) RGBColor(YN1003,-1,-1,-1,255,0,0) Forceredraw() }
// This checks to see if the Deed of trust is in the directory and puts a check mark in field element YNDeedOfTrust
iF FileExists(VDeedOfTrustYN) { YNDeedOfTrust = 1 RGBColor(YNDeedOfTrust,-1,-1,-1,0,255,0) Forceredraw() } else { YNDeedOfTrust = 0 RGBColor(YNDeedOfTrust,-1,-1,-1,255,0,0) Forceredraw()
} Forceredraw()
|