VB Database Creation

I am creating a database and its tables in visual basic.  How do I set a Date field to a short date format?  And how would I set a field so that it is required in VB code?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Internally the database only knows one form of Date type. There is no real way to create a "short date" type unless you save it as a string. This is slower than just using the normal date type.

You can display the date in short form by using the FORMAT command. You can make your own layout and either use or override the locale settings for dividers and such.

As for requiring a field, this is not normally done at the database level but you input validation routines don't enable the [Save/Update] button until that field has an acceptable value.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.