<div>
It seems that you cannot do it on table level<br />
you need to use VBA when you input the data from a form<br />
Take a look here : <a href="https://www.access-programmers.co.uk/forums/threads/make-the-first-letter-uppercase.219973/page-2" rel="ugc">https://www.access-programmers.co.uk/forums/threads/make-the-first-letter-uppercase.219973/page-2</a><br />
for an extensive list of options.
</div>


Will Schmidt

<div>
Thanks for helping me with this issue. &nbsp;The problem is now resolved
</div>


<div>
<div class="content wysiwyg-content">
I am wanting to set my first name and last name fields so that the first letter will always be caps and the rest as lower case in my tables in access. How do I do this, and isn't there a list of all the formatting &nbsp;options for tables in access?
</div>
</div>


I am wanting to set my first name and last name fields so that the first letter will always be caps and the rest as lower case in my tables in access. How do I do this, and isn't there a list of all the formatting  options for tables in access?

Setting a table format as Proper in access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.