Reverse display of stored checkmark

[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.

 

[strive4peace]

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
*