Text Formatting value in the Format Field of Table Design

[ragu]

Hi!
My field size is 30 characters maximum, data type TEXT. I am creating
Table entries using Design View. Interestingly, I must have referred to
several online docs. including Microsoft site. I just could not locate
an answer to a vey "simple" question. I would have thought this would
be Access 101 Fundamentals.

=========
Question:
=========
These are the criterias I wish to establish using Field Properties.
(a) Upto a Maximum 30 and Minimum 2 characters allowed.
(b) Numbers or Special or Punctuation Characters are not allowed in
this field.
(c) The first charcter should be automatically "capitalized". e.g John
(d) NULL entry will not be not allowed.
(f) The field should be left justified with no trailing spaces, if less
then 30 characters entered.

All of the above field properties to be active during data entry and
before populating in the datbase table. I am assuming, that the above
can be accomplished by defining the correct Formatting Properties for
the Field within a Table Design View.

"I sincerely believe that if you do not take care of formatting while
desigining the database tables, you could end up with a smorgasboard
look and feel of the table entries. What a mess it can be."

BTW - the respective TEXT fields will be populated with people's
FirstName
LastName
etc....

If I use MiddleName then I suppose I will also need to figure out
similar formatting properties, except it will be one character with a
mandatory period. For example, "M."

Please Help!
ragu

 

[MacDermott]

Hello, ragu!

Many of your requirements can be met by using an InputMask on your field.
Search on this in the Access Help file or your preferred instrument of
instruction.

However, in Access, tables are designed to store data; forms are designed to
interact with it. This includes data entry.
If you use a form, instead of having your users work directly in the table,
you'll have many more ways to control their options.

HTH