Change Field.required property in ADOX

How am I change the "required" property in the field column in ADOX. It is
default value as "Yes". I wanna change it to "No" when I create a new table
& field in ADOX statement.

thanks
dom

I'm trying to do the same thing. Can't figure out the syntax

Dim oTbl As ADOX.Table
Set oTbl = New ADOX.Table
'Add field
oTbl.Columns.Append "lngTestValue", adInteger

' this works, but now I want to set the "Nullable" property to true.
'I tried a bunch of things, but can't find the right syntax.



"Brendan Reynolds" wrote:

There is no "Required" property in ADOX. In ADOX, set the Nullable property
to False to require entry in a field, or True to allow records with no entry
in the field.

--
Brendan Reynolds (MVP)


dom wrote in message ...
How am I change the "required" property in the field column in ADOX. It is
default value as "Yes". I wanna change it to "No" when I create a new
table & field in ADOX statement.

thanks
dom

Now I remember why I dislike ADOX so much! :-(

On testing, I can't get my original suggestion to work either. But the
following seems to work. After running this code, when I look at the table
in design view, the first field ("ANonNullableColumn") has the Required
property set, the second field ("ANullableColumn") doesn't.

Public Sub TestNullable()

Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Dim col1 As ADOX.Column
Dim col2 As ADOX.Column

Set cat = New ADOX.Catalog
cat.ActiveConnection = CurrentProject.Connection
Set tbl = cat.Tables("tblTest")
Set col1 = New ADOX.Column
With col1
.Name = "ANonNullableColumn"
.Type = adInteger
End With
tbl.Columns.Append col1
Set col2 = New ADOX.Column
With col2
.Name = "ANullableColumn"
.Type = adInteger
.Attributes = adColNullable '------------------------------------NB
End With
tbl.Columns.Append col2

End Sub

--
Brendan Reynolds (MVP)


"John S" wrote in message
...
I'm trying to do the same thing. Can't figure out the syntax

Dim oTbl As ADOX.Table
Set oTbl = New ADOX.Table
'Add field
oTbl.Columns.Append "lngTestValue", adInteger

' this works, but now I want to set the "Nullable" property to true.
'I tried a bunch of things, but can't find the right syntax.



"Brendan Reynolds" wrote:

There is no "Required" property in ADOX. In ADOX, set the Nullable
property
to False to require entry in a field, or True to allow records with no
entry
in the field.

--
Brendan Reynolds (MVP)


dom wrote in message ...
How am I change the "required" property in the field column in ADOX. It
is
default value as "Yes". I wanna change it to "No" when I create a new
table & field in ADOX statement.

thanks
dom

That worked for me. Thaks for helping me out!

John

"Brendan Reynolds" wrote:


Now I remember why I dislike ADOX so much! :-(

On testing, I can't get my original suggestion to work either. But the
following seems to work. After running this code, when I look at the table
in design view, the first field ("ANonNullableColumn") has the Required
property set, the second field ("ANullableColumn") doesn't.

Public Sub TestNullable()

Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Dim col1 As ADOX.Column
Dim col2 As ADOX.Column

Set cat = New ADOX.Catalog
cat.ActiveConnection = CurrentProject.Connection
Set tbl = cat.Tables("tblTest")
Set col1 = New ADOX.Column
With col1
.Name = "ANonNullableColumn"
.Type = adInteger
End With
tbl.Columns.Append col1
Set col2 = New ADOX.Column
With col2
.Name = "ANullableColumn"
.Type = adInteger
.Attributes = adColNullable '------------------------------------NB
End With
tbl.Columns.Append col2

End Sub

--
Brendan Reynolds (MVP)


"John S" wrote in message
...
I'm trying to do the same thing. Can't figure out the syntax

Dim oTbl As ADOX.Table
Set oTbl = New ADOX.Table
'Add field
oTbl.Columns.Append "lngTestValue", adInteger

' this works, but now I want to set the "Nullable" property to true.
'I tried a bunch of things, but can't find the right syntax.



"Brendan Reynolds" wrote:

There is no "Required" property in ADOX. In ADOX, set the Nullable
property
to False to require entry in a field, or True to allow records with no
entry
in the field.

--
Brendan Reynolds (MVP)


dom wrote in message ...
How am I change the "required" property in the field column in ADOX. It
is
default value as "Yes". I wanna change it to "No" when I create a new
table & field in ADOX statement.

thanks
dom