<div>
In the onUpdate event write this code:<br />
<br />
MyField=Ucase([MyField])<br />
<br />
then you obtain only FRED
</div>


In the onUpdate event write this code:

MyField=Ucase([MyField])

then you obtain only FRED

<div>
Thanks Nico. &nbsp;The answer is clear enough, although it isn't what I wanted to hear.<br />
<br />
Are you in my time zone (gmt +2), or are you a night owl?
</div>


Thanks Nico.  The answer is clear enough, although it isn't what I wanted to hear.

Are you in my time zone (gmt +2), or are you a night owl?

<div>
I'm from The Netherlands (at gmt+1).<br />
You made me curious, what's the way you want to go ?<br />
<br />
Nic;o)
</div>


I'm from The Netherlands (at gmt+1).
You made me curious, what's the way you want to go ?

Nic;o)

<div>
I wanted to input directly to the table without a form and without code.
</div>


I wanted to input directly to the table without a form and without code.

<div>
That's not possible with access, but when you also have MS SQL then you could create a table with a StoredProcedure that performs a function like this automatically when inserting/updating a row.<br />
<br />
Nic;o)
</div>


That's not possible with access, but when you also have MS SQL then you could create a table with a StoredProcedure that performs a function like this automatically when inserting/updating a row.

Nic;o)

<div>
<div class="content wysiwyg-content">
I've got a text field that I want to use as the primary key, but it has to be case sensitive. &nbsp;That is, it has to allow for three recordes with key fields:<br />
fred<br />
Fred<br />
FRED<br />
<br />
How do you tweak the index to do this?
</div>
</div>


I've got a text field that I want to use as the primary key, but it has to be case sensitive.  That is, it has to allow for three recordes with key fields:
fred
Fred
FRED

How do you tweak the index to do this?

make key field case sensitive?

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.