Upper Case To Lower Case And Lower Case To Upper Case?


if there's any way for vba to detect if each individual character in a string is in caps, and if so, convert to lower case, and if it's in lower case, convert to capitalized The text will vary in length and content... so he wants to see how we can change: "This Is Strange" to "tHIS iS sTRANGE" "THIS IS STRANGE" to "this is strange" "this is strange" to "THIS IS STRANGE"

View Answers
Very similar questions


Batch Change File Names From Upper To Lower Case www.vbcity.com

I am looking for VB.Net code to change file names from upper case to lower case in Windows XP. I have copied files from an ISO 9660 data format CD to my Windows machine and in the copy process all of the file names were converted to upper case. Since I will be using these files in a Linux environment, I need to change them back to lower case. There are thousands of files and I am looking for code that will loop through all the folders, subfolders, and files and change the file names back to lower case.

Ignore The Difference Upper And Lower Case In Search With Db? stackoverflow.com

how i can ignore the difference upper and lower case in search with mysql

Simple Question > Change &"lower Case&" To &"UPPER CASE&" -solved- www.vbforums.com

hey yers, if i have a ton of text, which is lower case, how can i change it all to upper case?whats the funtion for this?TNX

Bulk UPPER Or LOWER Change www.excelforum.com

I am attempting to change a range of cells from lower case text to all upper case text.

Regex To UPDATE Upper Case To Lower www.phpfreaks.com

I am looking for a mysql quesry that will update any upper case characters in a a varchar column to lower case.

How To Set Table Names Upper Case In Mysql forums.mysql.com

we are using mysql(5.1) on windows,iam creating table name in upper case but mysql table created with lower case .

Every 2nd Letter UCase In String www.vbcity.com

Given a string, how can I make every 2nd letter upper case and every other letter lower case?ex:hEy ThErE, wUz Up?

Change All Upper Case To Lower Case In Text1 www.vbforums.com

How can change all upper case to lower case letter in text1 on a command click?

Function To Convert All To Upper Case? www.mrexcel.com

In cells A1:A45 i have all lower case names...how would i use a function to convert all to upper case

Converting To Upper Or Lower Case And Use For Mysql Search www.phpfreaks.com

what I'm trying to do is allow a user to enter their username and password in either upper or lower case and have it match the data in the MySQL database either way. For example they may input everything in upper case or maybe just the password in upper and the username in a mixture or upper and lower. Is there any way that this can be broken down into a simple MySQL search which would return a match no matter what case the characters are in?

Limiting Charaters www.vbforums.com

HiI have been given a project which requires limiting the characters to just numeric or just alpha (upper and lower case). I know how to do this using Asciieg. Private Sub text1_KeyPress (KeyAscii As Integer)Select Case KeyAscii Case 65 to 90 'Upper case chars Case 97 to 122 'Lower case chars Case Else KeyAscii = 0 Beep End SelectEnd SubThe boss was not happy because he did not want to pick up a key code all the time. I said fine usePrivate Sub txtEnterNums_KeyPress (KeyAscii As Integer)Select Case KeyAscii Case Asc("A") to Asc("Z")'Upper case chars Case Asc("a") to Asc("z")'Lower case chars Case Else KeyAscii = 0 Beep End SelectEnd SubStill not happy. He wants to create global variables eg. g_Alpha (abcd..ABCZ) and then call a function to the KeyPress saying if the key is equal to the global variable then OK, else not OK and don't allow the charater to be entered.Can this be done??? and how.Many thanksRobinPS still a newbie, lots of comments please.

Setting A Control Based On A Name Assigned By A String? social.msdn.microsoft.com

I have 26 buttons, each corresponding to the letter of the alphabet from A thru Z. I have a method that I've created that accepts a button as a parameter and sets the case to UPPER case if the text of the button is lower case or lower case if the text of the button is UPPER case. My method looks as follows: Private Sub ChangeLetterCase(ByRef MyButton As Button) If _upperCase Then MyButton.Text = Chr(Asc(MyButton.Text) + 26) [code]....

Use Of Upper And Lower Case With .... www.vbforums.com

Hi there,I like to use this code, but unfortunatly it lets me only use the Upper Case A to Z. If possible I would like to use the Lower case as well OR even better if choosing the first letter Upper Case the rest Lower case.How would I incorperate this into these Case Select Statements ???VB Code:Public Function'---'--- Turn input to upper case only.    sTemp = UCase(Chr$(KeyAscii))         Case 0: 'Numbers Only, from 0 to 9.            Select Case sTemp                Case "1", "2", "3", "4", "5", "6", "7", "8", "9", "0", ""                    VI = Asc(sTemp)                Case Else                    VI = 0            End Select         Case 1: 'Characters Only, from A to Z.            Select Case sTemp                Case "A" To "Z"                    VI = Asc(sTemp)                Case Else                    VI = 0            End Select         Case 4: 'AlphaNumeric Only,...With Comma.            Select Case sTemp                Case "1", "2", "3", "4", "5", "6", "7", "8", "9", ",", ""                    VI = Asc(sTemp)                Case "A" To "Z"                    VI = Asc(sTemp)                Case Else                    VI = 0 Thanks in advance aktell

Changing Case Of Text Strings Within A Range www.ozgrid.com

I receive data from different sources and one column is usually in upper case, but I prefer to use proper (title) case. The problem is that the data frequently contains text strings that should remain in upper case or should combine upper and lower case letters. Examples follow: Data received: COROLLA AE90, AE92 COROLLA SX, GTI Data should look like: Corolla AE90, AE92 Corolla SX, GTi Note that 'GTi' is upper case 'GT' and lower case 'i'. I've set up a spreadsheet 'CaseConverter.xls' as a look-up, with a range ('SpecialCase' - A2:A65536) featuring names, codes and acronyms represented correctly. Is it possible to use a macro to run Excel's global replace to search for upper case strings in one spreadsheet and replace with the correct strings from the other spreadsheet? The macro would have to loop through the entire 'SpecialCase' range and look in the supplied spreadsheet for versions of the data in the special case range without being case-specific. The supplied spreadsheet (see attached for example data) is called 'Application.xls'. Column B is what I'm trying to reach.

Testing The Case - Resolved www.vbforums.com

What I want to be able to do is test whether a character is in upper case or lower case and handle each differently....I've tried...VB Code:If LCase(cahracter) Then        msgbox "lower" Else       msgbox "upper"End If ...but this doesn't work as it's expecting me to convert the character to lower case and not test what the value is.Has anyone got any ideas?Many thanks,Nick

Change The Case Of Column Names Of All The Table In Db? stackoverflow.com

Is there any way using which I can change the case of column names. I need to do this as I have several tables in which some of them have column names all in upper case and some of them have column names all in lower case or tables has combination of upper and lower case column names.

Database That Shows Student Images? www.phpfreaks.com

I have a database that shows student images, in the format of 1234.jpg but the file name extension is in both upper case and lower case.My server OS is linux ubuntu. apache2 php5.Linux see these as 2 different file so will not show the upper case ones. 1234.JPGWhat i have already is working but for lower case only, i need something to detect when the extension is in uppercase and change accordingly. [code]....

[RESOLVED - Thanks!] Lock Uppercase In Textbox - Including Display?? www.vbforums.com

I have a program in which the user inputs text into text1... I convert the lower case to upper case using the following:LOT = UCase(Text1.Text)This works, but I'd like for it to display only upper case as the user inputs... The way it is the user inputs lower case, it shows lowercase and converts it to uppercase. I'd like something like a caps lock for that text box only... TIA

Change File Extension Upper/lower Case? www.sevenforums.com

Everyday I upload some files to my website and to simplify my website operations, I use the same filename and just upload a file with new information every day. The case of file extensions is of no consequence to Windows 7, but it matters to my website. I want to standardize on one case and it doesn't matter which as long it's the same all the time. I have one app, the snipping tool, which seems to generally make files using uppercase, but I have some existing files that are lower case. I have tried to get rid of the lower case extensions by deleting the file and then recreating it with the same name. When I do, Windows changes the case from upper to lower. If I simply create a brand new file with no previous instances of that file in existence (as far as I know), then the default case is upper. How does one go about converting all existing files of a particular type to a standard file extension case, be it upper or lower.

How To Get Cells To Only Have Upper Case Letters www.excelforum.com

Only have upper case letters. I am trying to get certain cells to only have upper case letters. each cell in the code will have a single letter typed in. I would rather have it as an event code (change while it is typed), but I have not grasped the whole thing yet. This code does not give me any errors, but it is not changing the lower case letters into upper case letters either. [Code] ......

VBA - ASCII Lower Case Help www.xtremevbtalk.com

Right now i have got some code, which lets me validate what a person inputs into a text box, but i cant get it to validate lower case letters. I want it to allow lower case as well as upper, but i cant seem to get it to work. The code i have at the moment is:Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)Select Case KeyAscii Case vbKeyA To vbKeyZ Case vbKeySpace Case vbKeyBack Case Else MsgBox "Invalid Character Entered" KeyAscii = vbEmpty End SelectEnd Sub

Preg_replace But For UPPER And Lower Case? www.dreamincode.net

what i can use instead of preg_replace? which does the same but for UPPER and lower case

Convert Russian Characters From Upper Case To Lower Case? stackoverflow.com

'm trying to change the case of russian characters from upper to lower. [code]....

Characters Within String www.vbforums.com

Hiyas,Is it possible to check the contents of a string, and alert the user if there's a character in there other then the alphabet (upper or lower case), or 0123456789?-Git

Generate A Random Password www.vbforums.com

Hi,What would be the easiest way to make a VB app generate a random password that contained numbers and letters (upper and lower case) of say 10 characters in length?CheersSimon

How To Know If A Character Is Upper Or Lower Case? www.vbforums.com

In VB, how can I tell if a character is Upper or Lower case?

Convert Text To Upper Case www.excelforum.com

Is there a way of selecting text and converting it all from lower to upper case?

Check Both Upper And Lower Case Words? www.vbforums.com

incorportaing i00 Spell check to be forced to check both upper and lower case words?

Web Forms :: Create A Regular Expression For The Password Textbox/unable To Limit The Length To 16 forums.asp.net

I need to construct a regular expression for the password textbox, Min:8,Max:16 and must include atleast a number(0-9),alphabets upper and lower case. I am unable to limit the length to 16. <asp:RegularExpressionValidator ID="RegEx" runat="server" ControlToValidate="Password" ErrorMessage="Password must be min:8,max:16 characters and include a number,alphabets upper case and lower case. "ToolTip="Password format is not correct" ValidationExpression="^(?=.{8})(?=.*d)(?=.*[a-z])(?=.*[A-Z]).*$"> </asp:RegularExpressionValidator>

App Store :: Apple Id Password Rules : "Not Contain More Than 3 Consecutive Identical Characters" discussions.apple.com

Rule #4 of the AppleID password restrictions states "Not contain more than 3 consecutive identical characters" -Your rule is actually "Not contain 3 or more consecutive identical characters".  "more than 3" would allow 3 consecutive characters, but it turns red ( invalid ) if this is attempted. Also, rule #1 states "Have at least one letter", which in standard English would include Upper and Lower case letters, but Apple's rule requires it to be "Have at least one lower case letter", while rule #2 "Have at least one capital letter" does correctly specify requiring at least one upper case.

Lower To Upper Case Query www.codingforums.com

I have some database entries from the same user, but with differences in the first letter (sometimes it´s upper, sometimes lower case), which reflects on some tasks the user should be able to perform...I´m trying to build a query that searches the whole database, finds the entries where the user has a lower case and updates it to upper case.

Capslock State And Shift State Is It On Or Off www.xtremevbtalk.com

Is there any simple code to get the state of the capslock and shift keys. Basically I want to know if when a letter on the keyboard is pushed what case will it be in (upper or lower case) becasue this can be achieved by either the capslock key or the shift keys I need code to determin what state the capslock is set to and whether either of the shift keys are depressed. Unless there is a simpler bit of code that will tell me whether im typing in upper or lower case.Any help would be greatThanksSC

Only Allow Upper/Lower Case Not All Upper Or All Lower www.mrexcel.com

Is there a data validation that will not allow all upper case or all lower case characters? For examples: Allow: John Doe 101A N Woodbine Street Disallow: JOHN DOE 101A N WOODBINE STREET Disallow: john doe 101a n woodbine street Or perhaps formatting that would convert the words to upper/lower case? Or, I would be interested in VBA if it is the only way.

Search A Content Which Is In Greek Letters Using Strtoupper And Strtolower? stackoverflow.com

I am currently working in a GREEK project. In that project all the contents are GREEK and in that i have a search functionality. Search process is good. But strtoupper() didn't convert the Greek language to upper case and strtolower() didn't convert the Greek language to lower case. But for English language its working fine. Is there any possible way to convert the Greek letters to UPPER and LOWER case.

Creating A Case Sensitive Parameter? forums.asp.net

I was wondering if there was a way to create a parameter for a method in VB.NET 2005, to select which case(upper, lower) to test for.For Example Function Afunction1 (ByVal aString As String, ByVal case As ......) As Boolean End Function Where case is the paramter for the user to set as upper or lower.

Does Anybody See Anything Wrong With This www.xtremevbtalk.com

I use Excel VBA 2003. I have to ctrl/alt/delete because the form won't start. i have the Load gamedata in workbook_openDim i As IntegerPrivate Sub Form_Unload(Cancel As Integer) If MsgBox("Use the Edit or EOW button!", vbOK, "Dodger Security") = vbOK Then Cancel = 1End SubPrivate Sub Frame1_Click()End SubPrivate Sub MultiPage1_Change()TextBox49.Text = ""TextBox51.Text = ""TextBox52.Text = ""TextBox59.Text = ""TextBox60.Text = ""TextBox61.Text = "1st Aid, "TextBox62.Text = ""TextBox64.Text = ""TextBox65.Text = ""TextBox63.Text = ""CheckBox1 = FalseCheckBox2 = FalseEnd SubPrivate Sub TextBox49_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox50_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox51_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox52_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox59_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox60_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox61_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox62_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Const KEY_SMALL_A As Long = 97 ' Define lower case a Const KEY_SMALL_Z As Long = 122 ' Define lower case z If KeyAscii >= KEY_SMALL_A And KeyAscii <= KEY_SMALL_Z Then KeyAscii = KeyAscii And Not &H20 ' Remove the upper case bit End IfEnd SubPrivate Sub TextBox65_Change()If TextBox65.Value = "" = False ThenTextBox52.Text = "EJECTED " + TextBox65.Value + " SUBJECTS"TextBox50.SetFocusEnd IfEnd SubPrivate Sub TextBox65_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii < 48 Or KeyAscii > 57 Then 'ASCII 48-57 = 0123456789 KeyAscii = 0 End IfEnd SubPrivate Sub UserForm_Activate()MultiPage1.PAGE3.ListBox1.AddItem "415/Fight/Verbal/DV/Unruly Fans/Assault"MultiPage1.PAGE3.ListBox1.AddItem "Alcohol Related/390/Under Age Drinking"MultiPage1.PAGE3.ListBox1.AddItem "Profanity/Obscene gestures/Obscene clothing"MultiPage1.PAGE3.ListBox1.AddItem "Code Green/Field Intrusion"MultiPage1.PAGE3.ListBox1.AddItem "Debris Throwing/Spitting"MultiPage1.PAGE3.ListBox1.AddItem "Theft/Auto Theft/Stolen tickets"MultiPage1.PAGE3.ListBox1.AddItem "Beach Ball/Inflatable/Flag/Banner"MultiPage1.PAGE3.ListBox1.AddItem "Illegal Ticket-Merchandise Vendor/Scalper"MultiPage1.PAGE3.ListBox1.AddItem "Trespassing/Dugout Club Jumper/Trespass Level"MultiPage1.PAGE3.ListBox1.AddItem "Vandalism/Damaged Property/Graffitti"MultiPage1.PAGE3.ListBox1.AddItem "Traffic Accident"MultiPage1.PAGE3.ListBox1.AddItem "Lost child/Missing Person"MultiPage1.PAGE3.ListBox1.AddItem "Field-Play Interference"MultiPage1.PAGE3.ListBox1.AddItem "Other See Note"MultiPage1.PAGE4.ListBox3.AddItem "Foul/Homerun Ball Injury"MultiPage1.PAGE4.ListBox3.AddItem "Slip and Fall"MultiPage1.PAGE4.ListBox3.AddItem "Heat Related"MultiPage1.PAGE4.ListBox3.AddItem "Traffic related injury"MultiPage1.PAGE4.ListBox3.AddItem "Pregnancy related"MultiPage1.PAGE4.ListBox3.AddItem "Major medical/Person Down"MultiPage1.PAGE4.ListBox3.AddItem "Seizure"MultiPage1.PAGE4.ListBox3.AddItem "Bee-Insect Sting"MultiPage1.PAGE4.ListBox3.AddItem "Other-See Note"'If MultiPage1.Value = 1 Then'End IfLabel82.Caption = Label80.CaptionMultiPage1.Value = 0CommandButton22.Visible = FalseEnd SubPrivate Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean)CommandButton22.Visible = TrueEnd SubPrivate Sub UserForm_Initialize()Dim a As Longa = ActiveWorkbook.Sheets.CountIf ActiveWorkbook.Sheets(a).Name = Date$ ThenActiveWorkbook.Sheets(a).ActivateRange("A1").ActivateElse Sheets("template").Select Sheets("template").Copy After:=Sheets(2) Sheets("template (2)").Select Sheets("template (2)").Name = Date$ With ActiveWindow .DisplayGridlines = False .DisplayHeadings = False End With With Application .DisplayFormulaBar = False .DisplayStatusBar = False End WithRange("A1").ActivateEnd Ifi = 1Label57.Caption = iLabel71.Caption = iLabel61.Caption = DateLabel75.Caption = Date Label80.Caption = InputBox("Dodgers Vs") 'ThisWorkbook.SaveAs "S:CP" & "16_" & Date$ & ".xls"End Sub

Remove Characters From A String www.vbforums.com

Hello,I have a string that can ONLY contain lower case letters, digits 0-9 and the hyphen character.1) How can I change upper case charaters to lower case?2) How can I strip away ANYTHING except lower case letters, digits 0-9 and the hyphen character?For example, in Perl:$domain=~tr/A-Z/a-z/;$domain=~s/[^a-z0-9-]//g;Simon

Other Option To Make Text All Caps forums.asp.net

I have a vb.net webpage that displays a bunch of data from my database. The users need this page to copy from and paste into a program. They asked that the webpage display text in ALL CAPS, eventhough the database stores the text in upper and lower case. I've tried using text-transform:uppercase as part of the .css [URL], and it displays the text in ALL CAPS. However, when the user copy/pastes from the page into another application, the text comes as upper and lower case. I tested the users comments by copying and pasting into Notepad, and sure enough, the paste is upper and lower case. how to get this to display ALL CAPS and paste ALL CAPS? (I'm on sql 2000, and the data is stored in upper and lower case)

Convert 1st Letter To Uppercase In SQL Comand forums.asp.net

Hi all!This is the problem:User enters student name, in the database, only the 1st letter is uppercase and the rest is  in Lower case.So, I want to fix this so as it is not case sensitive, i.e. the user can enter a name and it will return the recordwhether they enter it in upper or lower case.My Code:CvtUpperCase.Text = UCase(Content.Text)                //stores user's input    Select Case OptionChoice        Case "Student_FirstName"            MyCommand = New SqlDataAdapter("select * from [qryStudentDetails] where [qryStudentDetails].[Student_FirstName] like             '" & CvtUpperCase.Text & "'" , myConnection) ....Any ideas??

Change Input From All Upper Case Into A Normal Case? stackoverflow.com

I would like to change a string in php from all upper case to normal cases. So that every sentence would start with an upper case and the rest would be in lower case. Is there a simple way to do this ?

How To Create Random Strings With Parameters www.vbforums.com

I would like to make a program that generates a safe passwords for people to use. I want to make the passwords vary in length, include numbers, letters and upper case letters. I've been able to write code that prints out a random string but it includes unrecognized characters for most passwords. How would I write the code to create a random string that has parameters? (in this case upper case lower case letters and numbers).

How To Make Random String Of Just Letters And Numbers social.msdn.microsoft.com

I have to (for class) make a program that generates a safe passwords for people to use. My teacher wants us to make the passwords vary in length, include numbers, letters and upper case letters. I've been able to write code that prints out a random string but it includes unrecognized characters for most passwords. How would I write the code to create a random string that has parameters? (in this case upper case lower case letters and numbers).

Read Upper And Lower Case Letters Without Having To Put The Upper Case Letters In Select Case Statement www.vbforums.com

i have a program using a select case to convert letters to special charaters. My question is how can I get the code to read upper and lower case letters without having to put the upper case letters in my select case statement. Example: Part of my code is [Code]...

Delete Rows Where Columns Have Specific Lower/Upper Case Characters www.ozgrid.com

I am trying to detete rows that have several specific values, upper and lower case, (A-H) in any of several columns (B through H). I can delete upper and lower case "D"s in column B, but I'm having difficulty stringing together several variations and getting at the "D"s that are midstream (such as: ADeC), I tried ("*D*") to no avail. With . Cells(Lrow, "B") If Not IsError(.Value) Then '**** If LCase(.Value) = LCase("D") Then .EntireRow.Delete

Set The String To Lower Case? www.phpbuilder.com

so I can do this in PHP: PHP Code: echo ucwords(strtolower('heWletT paCKarD')); Output: Code: Hewlett Packard That's all well and good, but how do I do the same thing in MySQL? To get started I have tried this: Code: SELECT UPPER(LOWER('heWletT paCKarD')) But that just sets the string to lower case - then upper case, giving me: Code: HEWLETT PACKARD

Converting Address Upper Case To Upper And Lower - Version: 2003 (11.0) www.utteraccess.com

In need an example of a query to convert an all uppercase address field to an upper and lower case address field. I'm thinking the space before the words in the address may indicate the next letter to be upper case with following letters lower until the next space. If anyone has an exaple they could share that will work on multiple records with varying number and size words in the street name I would appreciate the help and an example.

Motorola Droid :: Keyboard Won't Auto-capitalize / How To Fix? androidforums.com

Since rooting & installing Bugless Beast, my on screen keyboard no longer defaults to upper case when I select a text field. It used to automatically show the upper case layout when I'd select say, the text message compose field, and then drop to lower case after the first letter. Now I have to manually capitalize the first letter. I've checked to make sure that auto capitalize is enabled in system settings. Anybody else have this problem and find a way to fix it?

Detecting Duplicate Entries And Display Message www.dreamincode.net

The following solution should allow the user to enter 'colors' to a combo box; however, if the color is already entered (in an upper, lower case or mixed case format), then the 'Duplicate Color' message should be displayed. I get the message, but my color is also being converted to an upper case format in the combo box. [Code]...

Converting Text From Upper Case Or Lowercase www.mrexcel.com

I have created a text convertor which will convert any text into upper case or lowercase (not very complex but very handy!) Is there anyway way that when text is in uppercase and I convert it to lower case that it makes every character after a full stop in upper case Example DAVID WAS NOT WELL. HE WENT HOME to David was not well. He went home I currently get david was not well. he went home.

Change Case Column Data forums.devshed.com

I have a table where one of the columns is "state" and for reasons I won't go into the the format of the state's initials is the first letter is upper case and the second is lower case.Please tell me there is a query I can run that will change * the records in the "state" column to all upper case...?

Converting The Case Of Text www.vbforums.com

I'm trying to convert a name from Upper Case to normal text eg JOE BLOGGS to Joe Bloggs. I've got a mental block on how to do it at the moment I've got this which converts the entire name from Upper Case to Lower Case, Not what I want! Dim MyString as stringDim MyArray() as stringDim i as IntegerDim LCaseString as stringMyString = "JOE BLOGGS" MyArray() = Split(MyString, chr(32),-1, 1) For i = 0 to Ubound(MyArray()) LCaseString = LCase(MyArray(i)) msgbox LCaseStringNext returns - joe bloggs Can anyone help? Regards Allan

Font Will Only Show Upper Case forums.adobe.com

When I type in my font, Photoshop CS3 will only show the upper case character, and when I attempt to type the text in lower case, it just types the upper case but smaller. I don't have any problems with any other fonts, and this font works fine in every other text program I am working with... I have tried un-installing and re-installing the font multiple times.

Dell Inspiron 1011 :: Keyboard Missing Many Of Letters In Upper Case en.community.dell.com

My qwerty keyboard is not doing or missing many of the letters in upper case - just lower case, and the letter 'L' seems to have given up completely - it will not type  neither lowercase or upper case. This problem exists in what seems to be all applications.

List With UPPER Case www.mrexcel.com

How can i use UPPER case formula in a list ? i have a on sheet4 at A1, source of data is sheet2 from A3:A5000. some entries in lower case, i want in list (A1) all entries UPPER case.

Small Query www.sqlteam.com

Hi, I need to display only the char having start with 'ACCT -AMOUNT',Now problem is that some records having the lower case character like 'acct amount'. But i want to display only the upper case char start with 'ACCT-AMOUNT'. I have to used the 'like ' statement but it is showing all the row inculding the lower case also. Please give me some clue reg. the issues. Thanks,BPG

Auto-generated Password - Which Characters Do You Disallow www.webmasterworld.com

When you autogenerate passwords, which characters do you keep out of your passwords? The obvious are 0 - zero O - oh (upper case) 1 - one l - el (lower case) and perhaps o - oh (lower case) Any others that lead to confusion and users writing to say they keep entering their passwords, but they can't log in?

Lower Case Convertion? www.phpfreaks.com

I have a site where a user can submit BBCode from a gallery host.� The problem is if the BBCode is using upper case, my site only recognizes the first thumbnail and then ignores the rest.� If the user converts everything to lower case, it all works perfect.� I have found the 'strtolower' function but I am not sure how to use it in the array.� I am just wanting to know how to change this to where it takes all incoming BBCode and converts it to lower case first and then submits it.

Printer Devicename - Can Change To Upper Case? bytes.com

One of my printers in my printer.devicename call returns in lower case. Isit possible for me to change it to upper case? I am also wondering how, inthe first place, this particular printer devicename is coded in lower case?Is there a way to change it back using VB6?Thanks

Ucfirst() Not Working bytes.com

i have a simple xml file and i use php5.1.2's dom xml to pull out an element's value. i then use use: // $type value all in lower case. $type = ucfirst($type); which doesn't work. prints out all in lower case. $type = strtoupper($type); works as expected - the output is all upper case. is this a bug or expected behavior?

ActionScript 2.0 :: Caps First Letter Of Every Word And Lower Case The Rest? www.kirupa.com

How would I upper case the first letter in a scentence and lower case the others. So that when im typing if i hit space then hit a new letter it is automatically caps. and the next is lower case till the next space?

ActionScript 2.0 :: Caps First Letter Of Every Word And Lower Case The Rest www.kirupa.com

How would I upper case the first letter in a scentence and lower case the others. So that when im typing if i hit space then hit a new letter it is automatically caps. and the next is lower case till the next space? (kinda like in guildwars their naming system).

My Problem Also Not Solved Yet social.msdn.microsoft.com

Upper case sentece in normal case sentence

Case Sensitivity From Oracle To Access www.xtremevbtalk.com

I have set up an ODBC link to an Oracle database using Access. What I have found is there are records with fields that have some values in upper case and some in lower case (Proper Case as well). When I query through Access, it appears to follow the case sensitivity rules of Oracle. That is, I would have to set my query criteria to be "abc" or "ABC".Does anyone know if I can set my Access database link to ignore this rule so I do not have to convert the fields using the CASE functions before I query?Thank you

Change Case To 'Sentence Case' www.xtremevbtalk.com

In MS Word, there is a menu option available that lets you change the case of the selected text to either Upper Case, Lower Case, Title Case, or Sentence Case. I've done the first three using StrConv function, but for the Sentence Case, I'll actually have to code it myself.I was just wondering if anyone had done something like this or otherwise to get some ideas. So far, I'm thinking something like this:1. Change to all lower case2. Replace all instances of " i " with " I ".3. Replace all instances of " i'" with " I'".4. Find all instances of "." "?" "!" and change the first non-space character to upper case.I can do all of this, but I'm guessing that I'm missing a thing or two, so I figured I'd ask for some input from you guys."The LORD is my strength and my shield" - Psalms 28:7

Datagrid - Column To Upper Case www.codeguru.com

I am new to Visual Basic 6 and trying to work with the DataGrid control.I want to have the user's column information for certain columns become Upper case if they type in a lower case letter.I have tried the following below:Private Sub grdSupplier_BeforeColUpdate(ByVal ColIndex As Integer, OldValue As Variant, Cancel As Integer) Select Case ColIndex Case 6, 11 To 14 grdSupplier.Columns(ColIndex).Value = UCase$(grdSupplier.Columns(ColIndex).Value) Case Else End SelectEnd SubWhen I change a column to "f" for example, I want to see "F" after the user moved to another column or presses <Enter>.Thanks for your time.Scott

What Are The Benefits Of Upper-camel Case For Class Names www.phpfreaks.com

I've seen many people use lower camel case (thisIsAnExample) for variable names, and upper camel case, also known as Pascal case�(ThisIsAnExample- sorry, I'm sure you know this already)� for class names, and possibly for method names and property names. But it seems simpler for me to just use all lower camel case.� If I use both, what good does it do?� And if I do use it, it brings up the question of "well, now what about the name of a library I write?� Or an entire piece of software?� Are those upper or lower?"� And it just seems simpler to do all lower.

Upper Case / Lower Case www.vbforums.com

Hi everyone,For part my university assignment, I have to write a program that will change the case of certain letters of a word. I got the code, and it 90% works. It takes the word (a last name inthis case), it finds the letters, and it converts lower case letters to upper case. However, it doesn't convert upper case letters to lower case. I've posted the code, if anybody can see an apparent error, I'd really appreciate if you pointed it out to me. Thanks. VB Code:Private Sub cmdModify_Click()    Dim sName As String    Dim sLastName As String    Dim sLetters As String    Dim iCtr As Integer    Dim iCtr2 As Integer    sLetters = "acfsv"        sName = txtName.Text    sLastName = Mid(sName, InStr(1, sName, " "))        'replacing loop    For iCtr = 1 To Len(sLastName)        For iCtr2 = 1 To Len(sLetters)            If Mid(sLastName, iCtr, 1) = Mid(sLetters, iCtr2, 1) Then                If InStr(1, UCase(Mid(sLastName, iCtr, 1)), Mid(sLastName, iCtr, 1), 0) Then                    Mid(sLastName, iCtr, 1) = LCase(Mid(sLastName, iCtr, 1))                End If                If InStr(1, LCase(Mid(sLastName, iCtr, 1)), Mid(sLastName, iCtr, 1), 0) Then                    Mid(sLastName, iCtr, 1) = UCase(Mid(sLastName, iCtr, 1))                End If            End If        Next iCtr2    Next iCtrlblReciept = sLastNameEnd Sub

Upper And Lower Case In VBA www.mrexcel.com

I have this code (this is just a snippet) For Each cel In Range("E6:AI15").Cells If IsError(cel.Value) Then Else Select Case UCase(cel.Value) Case "H" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 3 Case "S" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 10 but I want the cells to accept both upper and lower case values and format the cells accordingly ie. H or h, S or s

Case Sensitivity :: Table Names forums.devshed.com

I have created a new datadase, the tables and column names are written in lower case. I also have an existing program that has a select statement written in upper case. My problem is that i get an error when i run the program coz mysql is case sensitive to tables and columns. Is there a way to change the properties of mysql so that will not be case sensitive?

Argh!! Brain Lock www.xtremevbtalk.com

Okay, I'm trying to remember the name of the function that lets you change the case of a text string to either all upper case, all lower case, or "title case" (I think that's what it's called - so that "star wars" becomes "Star Wars"). I'm not referring to the UCase$ and LCase$ functions, but there's another... I just can't think of it.Or am I imagining things?"The LORD is my strength and my shield" - Psalms 28:7

First Letter Capital More Than One Word social.msdn.microsoft.com

Here is my question: Can you set this code up to do more than one word ex: I have names like Mc Donald, or Brook-Smith and the are lower case like the code states?? � upper(left(client.first,1))+ lower(right(client.first,len(client.first)-1)) +' '+ upper(left(client.last,1))+ lower(right(client.last,len(client.last)-1)) As 'Full Name'

IWeb 09 :: Cannot Change Site Name In Publishing Settings discussions.apple.com

On the "site publishing settings" page at the top, under publishing, the second box asks you to type your site name. I need to make a correction to the site name I have - specifically to change the first letter from upper to lower case. Whenever I change the letter to lowercase it automatically goes back to upper case. Information: Macbook Mac OS X (10.5.8)

UPPER Case Constraint forums.databasejournal.com

Folks, what script must I use, as a part of CREATE TABLE, to automatically convert characters to UPPER case on insert? I wrote <CHECK (country = UPPER (country)> in the CREATE TABLE, which was wrong, because the values were still in the lower case. The sample script is: CREATE TABLE address (street varchar(40), city varchar(20), state char (2), zip varchar (10), country varchar (20)) When a user types "Canada", I want the inserted value be "CANADA" Any help is greatly appreciated.

Resizing Forms www.vbforums.com

I tested some resizing utilities (Shareware ActiveX Controls and pure VB-Code) and made theexperience, that all tools worked (more or less fast) as long as the form is not a MDI-Child.When the form is a MDI-Child only the upper partof the form is shown. The form consists of a ssTab-Control in the upper part and some command-buttons in the lower part of the form.The resizing itself worked in both cases butin the MDI-Child case, i do not see the command buttons, even when the form is maximized.Any ideas ? Thanks in advance for some hints.

Return Value Only If All Words Are Uppercase? www.excelforum.com

I have about 5000 rows with mixed upper & lower case words. I am trying to get only values if all words are upper-case. I have office 2013.

Checking The DB For Either Lower Case Or Upper Case In A Query ? phpbuilder.com

I have people submitting a form twice, one with lower case letters and one with capital letters. Of course I have it checking to see if email is in DB, and this is their way of submitting twice. Is there a way to prevent this by checking the DB for either lower case or upper case in a query ? Or maybe they will even do both lower and upper case at same time. Example : SOMENAME@SOMESITE.COM somename@somesite.com SoMeNAME@soMeSiTE.CoM Many variations they try and succeed.

Snow Leopard :: Preview PDF Files Drop Letters When Printed / Sort It? discussions.apple.com

I have a problem with PDF's printing without lower-case letter o's and upper-case X's. This is both to my Brother Laser Printer AND my HP C309. It may be Mac software at a low level, because when I print a PDF to Yojimbo, the lower-case o's and upper-case X's are also missing. There may be others, but those are the two letters I noticed. The screen displays are OK and PDF's generated to Yojimbo from Safari are OK. The same downloaded PDF file that dropped the o's and X's print OK when opened with Acrobat Reader. Is this a Preview problem? I'm running Preview Version 5.0.3 (504.1). Information: iMac 20" Mac OS X (10.6.5)

2 Quick Questions www.vbforums.com

Ok I have an Input box which opens when I open the program and asks for the low number (between 0-30) how do I get it to keep asking me for the number until it's correct?AndHow do I get something I type in a text box to match with something I've loaded from a text file to match, when upper case and lower case in involved?

How Do You Force CaPital Letters In Textbox? (RESOLVED) www.vbforums.com

Rather than have to code to accept a mixture of upper and lower case letters. Is it possible to set a text box to accept key stokes regardless as to wether they are lower case or caps. But actually display them as all CAPITAL letters inside the text box.This needs to happen on the fly as the user types int the text box.

Lower/upper Cases forums.mysql.com

I have this query where I want to display the results in the lower case but the first letter should be in the upper case. Can anybody please advise how to do it? select LOWER(f.flt_to) from flight_profiles f;

Find Characters That Are Lower Case bytes.com

I have a string and want to find any character that is lower case, any ideas how to do this, is there a function that will decipher between upper and lower case?

Uppercase &amp; Lowercase Method www.vbforums.com

I am writing a program that stores names & addresses how do i when inputting a name for instance get the upper or lower case method to force it to display this format.eg Mr Robert Briggscapital letters for the first part of the string and lower case for the restI am using VB4 ProfessionalHope someone can helpmany thanks

Keypress Upper / Lower Case www.vbforums.com

I'm currently using this bit of code to let only Y, N, and Backspace be typed in my textbox: [code] My problem is that when I debug, the "n" has to be capitalized in order for it to show up in my textbox and the "y" has to be lower cased. Is there anyway that I can bypass this to where it doesn't matter wether or not it is upper or lower case?

Convert An Entire Table To Lower Case? www.access-programmers.co.uk

I need to convert an entire table to lower case.. The table happens to only have one column in it, so each record only has one field.. How do I convert the entire thing to lower case? I can not just convert the display info to lower case, this table is used as a cross-reference data table and I need to physically convert all the data in the entire table to lower case. Oh, and I need this to be a macro of some sort, since the data is re-imported on a regular basis, and will re-convert to upper case on the import. Thanks, Bill

Case Sensitive Problem www.phpfreaks.com

I ave develoed a page in PHP using dream weaver. and run that page on IE7.My page contains both upper case and lower case letters.But the Browser shows all in Capital Letters.Please help me on this issue.. How can i change my page to case sensitive?

Make Search Function Not Case Sensitive stackoverflow.com

I am trying to search MySQL database with a search key entered by the user. My data contain upper case and lower case. My question is how to make my search function not case sensitive. ex:data in mysql is BOOK but if the user enters book in search input. The result is not found. My search code [CODE....]

Case Sensitive Question www.vbforums.com

in vb, how do u convert a string that is typed into text1.text into all upper case, or all lower case??and in searchin records in a database, is vb case sensitive?

How Do You See If Letter Is Upper Case Or Lower? www.vbforums.com

I need a way to check if a character is upper case or lower case or is there a way in vb to reverse the case of a string like if it werehELLO it would change to Hello?and vica versa

How To Change The Notepad Font From VB www.codeguru.com

Hi, I want to print a string in notepad. If i print the same string in Lower or Upper cases it should occupy same width in both cases. In that case i want to change the font of notepad How..?Is there any other porcedure to get the same result ..?Pls help me.

Need Help W/ Number Range Search Code www.vbforums.com

i have this code below, which for some reason works with range numbers of 4 and 5 digits, but not with 3e.g. works with lower range 1000 upper 2000 and lower 10000 upper 20000but if i trylower 100 upper 200 it wont return a resultCode:Private Sub Form_Load()Dim MyData As String, Pointer As Long, NumFound As LongConst LowLimit = 1000Const UpLimit = 1200Dim lngPos As LongDim intCount As IntegerDim intFile As IntegerDim strRecord As StringDim strData As StringDim boFinished As BooleanintFile = FreeFileOn Error Resume NextKill "C:search.txt"On Error GoTo 0dfile = "C:myfile.txt"ofile = "C:search.txt"Open dfile For Input As intFilestrData = LCase$(Input(LOF(intFile), intFile))Close intFileintFile = FreeFileOpen ofile For Output As intFileFor i = 1 To 4 Do Pointer = InStr(Pointer + 1, strData, Format$(i, "#")) If Pointer Then On Error Resume Next NumFound = Val(Mid$(strData, Pointer, 4)) If InStr(Mid$(strData, Pointer - 1, 5), vbTab) > 0 And InStr(Mid$(strData, Pointer, 5), vbTab) > 0 Then Select Case NumFound Case LowLimit To UpLimit lngI = InStrRev(strData, vbLf, str$(Pointer)) + 1 lngJ = InStr(str$(Pointer), strData, vbCr) istr = Mid$(strData, lngI, lngJ - lngI) Print #intFile, istr Case Else End Select End If On Error GoTo 0 Else: Exit Do End If LoopNextClose intFileEnd Subanyone have an idea as to why?thx

Make 1st Letter Upper Case www.mrexcel.com

I have cells that have 1 or 2 words in them. Is there a formula I can use that will make the 1st letter of each word Upper Case. The whole range started out all caps. I used =lower(a1) to make them all lower. Now I just need 1st letter of each word upper.

Ignore Case Sensitivity While Comparing Strings? stackoverflow.com

Im trying to compare words for equality, and the case [upper and lower] is irrelevant. However PHP does not seem to agree! Any ideas as to how to force PHP to ignore the case of words while comparing them ?? $arr_query_words = array( "hat","Cat","sAt","maT" ); // for each element in $arr_query_words - for( $j= 0; $j < count( $arr_query_words ); $j++ ){ // Split the $query_string on "_" or "%" : $story_body = str_replace( $arr_query_words[ $j ], '<span style=" background-color:yellow; ">' . $arr_query_words[ $j ] . '</span>', $story_body ); // --- This ONLY replaces where the case [upper or lower] is identical -> } Is there a way to carry out the replace even if the case is different?

Case Sensitive Sorting www.excelforum.com

I have been battling with excel for weeks now trying to get some data to display the way I want it to. The plan is to enter (into individual cells) some letters, some lower case, some upper case ie, A A a A a C d. Some of these will be displayed together in another cell like this: AAaA, AaCd. My problem is that I want them all to be displayed Upper case letters first, lower case second like this: AAAa, ACad. No amount of my inexperienced fumbling with excel's tools has worked so far. I am playing around with a table for genetics so if my results in a cell are aAbBCcdD, I need it to display: AaBbCcDd. Is it possible?

IWeb 09 :: Fonts - Mail The Site Address discussions.apple.com

I have recently published my website and viewed it on PC and discovered that all the fonts was not in the format I had chosen when building my site. The family of font I chose was Herculanum in upper case. When choosing this font, upper case is the only choice- lower case is not an option. The PC had all the text scrambled, in lower case and in another chosen font. The PC is a Microsoft Windows with a 2008 Vista operating system. Does this have any bearing on my dilemma. Could Windows have not recognized my chosen text and went to default mode? When I mail the site address to my Mac everything is as it should be

Combobox Autocomplete Lower-/uppercase Problem www.vbforums.com

Hi!I've been using this Autocomplete code for some time now, but it does something I do not want it to do When I added a word like ALFA (all capitals), and I then type Al (second letter is a normal letter), then the code changes this to AL, because that's the match it found, in other words, it does not differentiate between lower case and upper case.Could anyone help me finding out how I can use this code, but with the ability to enter lower case as well as upper case letters?Here's the code:Code:Dim FindMatch As LongDim ComboEntry As StringOn Error GoTo ErrRtn If KeyAscii = 8 Then If CB.SelStart <= 1 Then CB.Text = "" AutoComplete = 0 Exit Function End If If CB.SelLength = 0 Then ComboEntry = UCase(Left(CB, Len(CB) - 1)) Else ComboEntry = Left$(CB.Text, CB.SelStart - 1) End If ElseIf KeyAscii < 32 Or KeyAscii > 127 Then Exit Function Else If CB.SelLength = 0 Then ComboEntry = UCase(CB.Text & Chr$(KeyAscii)) Else ComboEntry = Left$(CB.Text, CB.SelStart) & Chr$(KeyAscii) End If End If FindMatch = SendMessage(CB.hWnd, CB_FINDSTRING, -1, ByVal ComboEntry) If FindMatch <> CB_ERR Then CB.ListIndex = FindMatch CB.SelStart = Len(ComboEntry) CB.SelLength = Len(CB.Text) - CB.SelStart AutoComplete = 0 Else If LimitToList = True Then AutoComplete = 0 Else AutoComplete = KeyAscii End If End If Exit FunctionErrRtn: AutoComplete = 0Thanks in advance!DaveG.

WH_CBT Hook (local) Causes GPF? www.vbcity.com

Hi,I have written a WH_CBT hook handling code and it works OK except for where Code = WHCBT_SYSCOMMAND...which causes a GPF.The code (snippet) is ...Code:Case HOOKPROC_CBT '<--CBT Hook is triggered    Code = Arguments(1)    wParam = Arguments(2)    lParam = Arguments(3)    Select Case Code '<--What type of message?    '....    Case Case Code = HCBT_SYSCOMMAND        Dim ptMouse As New APIPoint        Dim activeBy As SystemCommandActivationMethods        Select Case APIDispenser.HiWord(lParam)        Case 0            activeBy = SCAM_BYMNEMONIC        Case -1            activeBy = SCAM_BYSYSACCELERATOR        Case Else            activeBy = SCAM_BYMOUSE            ptMouse.y = APIDispenser.HiWord(lParam)            ptMouse.x = APIDispenser.LoWord(lParam)        End Select        '\ Only the upper 3 bytes are used - the lower 4 are reserved for the system...        wParam = (wParam And &HFFF0)        Select Case wParam        Case SC_HOTKEY            '\ A window is being activated by a hotkey            wndThis.hWnd = lParam            RaiseEvent ActivateWindowByHotkey(wndThis, Cancel)        Case SC_TASKLIST            RaiseEvent StartMenu(activeBy, ptMouse, Cancel)        Case SC_MONITORPOWER            If lParam = 1 Then                RaiseEvent MonitorLowPower(activeBy, ptMouse, Cancel)            ElseIf lParam = 2 Then                RaiseEvent MonitorPowerOff(activeBy, ptMouse, Cancel)            End If        Case SC_CONTEXTHELP            RaiseEvent InitiateContextHelp(activeBy, ptMouse, Cancel)        '.......        End Select        If Cancel Then            Arguments(4) = 1        End If     '.......Does anybody have any experience of this hook proc that could guide me to finding the source of the GPF?Many many many thanks in advance,  Duncan - - - - - 8< - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -NEW - The printer usage monitor application- - - - - 8< - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Make Upper Case www.codeguru.com

Is under VB a function with which I can make a string upper-case.Thanks

Converting To Upper Case www.xtremevbtalk.com

Need help!I'm trying to make an object print in upper case using "with selection" from the word library. I need to make the frmCitation.cboRrank.Text print in upper case from this point instead of having the user enter the info in upper case. Here is a snippet of the code:Public Sub Print() ActiveDocument.PageSetup.TopMargin = InchesToPoints(3.875) ActiveDocument.PageSetup.BottomMargin = 0 With Selection .ParagraphFormat.Alignment = wdAlignParagraphCenter .Font.Bold = 1 .Font.Size = 11.5' name .Font.Size = 15 .ParagraphFormat.SpaceBefore = 30 .Paragraphs.Format.Style .TypeText Text:=frmCitation.cboRrank.Text & vbUpperCase & " " & frmCitation.txtRfirstname.Text & vbUpperCase & " " & frmCitation.txtRlastname.Text & vbUpperCase & vbCrLf