dbBoolean Display

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

Guest

How can I set the "Display Control" on a Boolean Field Type to "Check Box"
using VBA?


Thanks


Ross
 
Ross said:
How can I set the "Display Control" on a Boolean Field Type to "Check Box"
using VBA?
Click to expand...

You may have additional things to do, but this is the core
idea:

Dim db As Database
Dim tdf As TableDef
Dim fld As Field
Dim prp As Property

Set db = CurrentDb()
Set tdf = db.TableDefs("zJunk")
Set fld = tdf.Fields!FieldName
Set prp = fld.CreateProperty("DisplayControl", _
dbInteger, acCheckBox)
fld.Properties.Append prp

Set prp = Nothing
Set fld = Nothing
Set tdf = Nothing
Set db = Nothing
 
Marshall,

I have done those other things but this is what I couldn't find!

Set prp = fld.CreateProperty("DisplayControl", dbInteger, acCheckBox)

Thank you!

Ross
 
Back
Top