Hi - first post!
I am using vb.net to work with an MS Access database. I want to programatically change a parameter of a particular field, such as the "Format" selection in an MS Access "Date/Time" field.
I'd like to be able to change the Format of a Date/Time field to a "Short Date" - for example:
str = "ALTER TABLE ContactData ALTER COLUMN [ADVdate] Format: 'Short Date' NOT NULL"
How do I know what choices there for adding parameters to an ALTER COLUMN string?
Is there a list somewhere of all the Parameters I can use after the "ALTER COLUMN [fieldname]..." expression? If so, where would I look?
Thanks for your reply.
Kim
I am using vb.net to work with an MS Access database. I want to programatically change a parameter of a particular field, such as the "Format" selection in an MS Access "Date/Time" field.
I'd like to be able to change the Format of a Date/Time field to a "Short Date" - for example:
str = "ALTER TABLE ContactData ALTER COLUMN [ADVdate] Format: 'Short Date' NOT NULL"
How do I know what choices there for adding parameters to an ALTER COLUMN string?
Is there a list somewhere of all the Parameters I can use after the "ALTER COLUMN [fieldname]..." expression? If so, where would I look?
Thanks for your reply.
Kim