R Ramshan Registered User. Local time Today, 14:06 Joined Aug 17, 2011 Messages 48 Dec 7, 2011 #1 Do we have any function that can be incorporated in forms that will change all entries in to CAPITALS when I hit a button? Thanks in advance
Do we have any function that can be incorporated in forms that will change all entries in to CAPITALS when I hit a button? Thanks in advance
V vbaInet AWF VIP Local time Today, 22:06 Joined Jan 22, 2010 Messages 26,374 Dec 7, 2011 #2 There's UCase(), StrConv(), Format property and the Format() function.
John Big Booty AWF VIP Local time Tomorrow, 07:06 Joined Aug 29, 2005 Messages 8,262 Dec 7, 2011 #3 Or simply put the Greater Than (>) symbol in the Format Field at either Table or Form Level