Control alters text to HTTP

[JeroenMioch]

When users enter the letters HTP in capitol letters in one of my unbound controls, this is altered by access in HTTP ! This behaviour doesnt happen when they enter it in lower case.

The control automaticly corrects the entering of lower case letters in capitol letters.

The control holds lisenceplate numbers, so when they enter 23-HTP-7 it turns into 23-HTTP-7 afterupdate.
When i enter 23-htp-7 it turns into 23-HTP-7 like it should.



Does anyone recoqnise this behaviour, and more important know how to correct this ?

Greetings, Jeroen

[Bob Fitz]

The control automaticly corrects the entering of lower case letters in capitol letters.

How are doing this.

[Micron]

Doesn't sound like normal behaviour for a db and and unbound textbox.
Is this an adp project or database?
Do you have the Is Hyperlink property set to 'yes' on the property sheet for the textbox?
Is newly added text underlined if you move the focus from the control?
Maybe post your afterupdate code, or add another unbound textbox and see if it exhibits the same behaviour. If not, compare all the properties between the two for clues.

[JeroenMioch]

How are doing this.

Me.FilterKenteken = UCase(Me.FilterKenteken)

[JeroenMioch]

Doesn't sound like normal behaviour for a db and and unbound textbox.
Is this an adp project or database?
Do you have the Is Hyperlink property set to 'yes' on the property sheet for the textbox?
Is newly added text underlined if you move the focus from the control?
Maybe post your afterupdate code, or add another unbound textbox and see if it exhibits the same behaviour. If not, compare all the properties between the two for clues.

Its a normal .mdb database
No its not a hyperlink field of any sorts, just a textbox control.
I don't get any hits on the problem if i google it. It just seems like a bug.

Any idea's would be appreciated.

[Missinglinq]

That has to be the AutoCorrection Gnome at work! Try this

• Go to Options - Proofing and click on the AutoCorrection Options button.
• Scroll down the Listbox to htp, select it and hit Delete. There are several variations for htp so you may have to delete all of them.

I assume this is the same in v2010 as it is in v2007.

Linq ;0)>

[JeroenMioch]

Thats it !!
Thanks mate

[Missinglinq]

Glad we could help!

Linq ;0)>