How to access and amend a field property in a database

[MissyEd]

Hi all

I would like to set up a database through VB, Ive managed to create the table and fields (table = ReceivedDbs, fields = Date_Created (Date) and Branch_Number(Long) but I want to do more like:

1. Set the primary key and indexes. I want to use both Date_Created & Branch_Number as the primary key.

2. Set more properties of the fields i.e:
Date_Created - format = dd/mm/yyyy
- caption = "Date Created"
- default value = Now()
- Indexed = Yes(Duplicates OK)
Branch_Number - decimal places = 0
- caption = "Branch No."
- Indexed = Yes(Duplicates OK)

However, I have been tearing my hair out on this one. Any one have a clue ?

Missy Ed
msedbbw@hotmail.com

Looking to exchange ideas and tips on VB and MS Access. Drop me a line: msedbbw@hotmail.com