Problem with UCase font

[StephenB]

I have table [Members] with four field for member's last name, first name, middle initial and ID number. The primary key is [MemID]. I use form A to enter members into the [Members] table. I also have Table [Case] which has field [MemID] looking in the [Members] table to pull members from. I have [Case].[MemID] populating with the last name of the member. I have form [Case] that I use to populate the [Case] table. It's on this form that I look up and select a member. On the [Case] form I have fields [MemId], [FirstName] and [MidInit]. All of the mentioned fields (except for [Case].[MemeID] are set to UCase with ">".

My problem: The font on field [MemID] on form [Case] is displayed as black. I don't have this problem with [FirstName] or [MidInit]. All font on the form is set to white. The font on the [MemId] field on the [Case] form is set to white.

I've noticed that when I take the UCase off of the [Members].[LastName] field that the font for that field in [Case] returns to normal (white), however [LastName] is no longer UCased. I've tried just having UCase on the [Members] form and the text is diplayed as UCase, but it's stored in the tabe as lower case if entered that way.

I want all text entered, displayed and stored as Ucase and the font on form [Case].[MemId] displayed as normal (white in this case). Any suggestions?

 

[Fizzio]

I posted some code here
http://www.access-programmers.co.uk/ubb/Forum1/HTML/008521.html

to convert any input to uppercase.
HTH

 

[StephenB]

Thanks again, Fizzio, that worked great. It even took care of the black font.

Any comment on why the font turned black in the first place?
Stephen

[This message has been edited by StephenB (edited 05-22-2002).]

 

[Fizzio]

No Idea