Reverse display of stored checkmark

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any ideas how to reverse the display of a checkmark field within a hidden
system table? I would like the MSysIMEXColumns.SkipField that I have
displayed on a subform to be shown/interpreted as "include" rather than
"exclude".

Here's why... I have built import specifications based on existing tables
where the import data is stored in the MSysIMEXSpecs and MSysIMEXColumns
system tables; and I have built an import form\subform based on these system
tables. The subform displays filtered SkipColumn & FieldName values of the
selected import specification from the main form; and I've writton code that
automates import based on these user selections. All works fine except I am
sure that the SkipColumn checkmark will be counter-intuitive to my end users.
I think I know how to process the opposite result behind the scenes, but I'm
not sure how to display the opposite value to the end user.
 
Hi LF,

In the RecordSource for the form:

field --> SkipColumn

field --> IncludeColumn: IIF(not SkipColumn, true, false)

on the form, since IncludeColumn will be a calculated control, use the
Click event to flip SkipColumn, save record, and refresh the form (or
requery IncludeColumn)



Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top