Ucase Question...
Jun 23, 2005
We have a situation where mail sent to Canada using the mail merge is being returned because it's not in all caps. I've used the following code in each fields after update:
Me.ActiveControl = UCase(Me.ActiveControl)
What I'd like to do is make it so only the Canadian addresses are in upper case. This would be determined by what is in the state field. AB, BC, etc. Any U.S. address would need to be in proper case where the first letter of each word is capitalized.
Can this be done?
View Replies
Mar 17, 2005
hi all
I have a form that has textboxes, a combox and a subform, when i complete a record, I will like everything to capitalized in the table but I can't seem to figure out how to do this on the subform fields.
I tried the ucase function for the after update but the subform doen't have an after update
View 3 Replies
View Related
Jul 12, 2005
Hi,
I'm using code which convertes names of costumer into upper case when user type the name into control. But there is a problem.
If letters č,š,ž are pressed they are not converted to upper case.
Code:
Private Sub Customer_KeyPress(KeyAscii As Integer)
On Error Resume Next
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub
please help
View 3 Replies
View Related
Apr 14, 2006
In my Access 2000 database I have a form which displays patients' treatment details.
I have a text box in which the Forename and Surname are concatenated to display the full name and the Surname is included in a UCase function so that it is displayed in capitals:
=[tblPatient.Forename] & " " & UCase([tblPatient.Surname])
This works fine on my office computer (XP professional), but when I run it on my home machine (XP Home) in order to carry out further development, the UCase function is not recognised. I get the #Name? message in the text box and if I try altering the formula I get the message:
The function you entered can't be used in this expression
*You may have used a DoEvents, LBound, Ubound, Spc or Tab function in an expression
*You may have used an SQL aggregate function, such as Count, in a design grid or in a calculated control or field
As far as I know, the versions of Access are exactly the same on my home and office machines.
Is anyone able to shed any light on why this function works on one machine and not the other?
Thanks,
Jules
View 2 Replies
View Related
Oct 27, 2006
A few years ago, I wrote an application in Access 2000 that worked fine. Last year I upgraded to Access 2003. Everything works the same, but the UCase, Left and Right text functions give error messages when used in queries. Anyone have a way to fix this?::confused:
View 2 Replies
View Related
Nov 1, 2004
I am taking an online Access class.
I have an assigment to create an Update Query.
The Update Query is to prompt name entry in all lower case, then convert it to upper case.
The Update Query must do the formatting, no utilizing the Input Mask.
This is the code I thought would work.
Field: Firstname
Table: Good Data
Update: UCase([Firstname])
Criteria: [Enter first name in lower case]
The parameter box part of the Query runs fine. When I run the Query the parameter dialog appears instructing you to enter your firrst name in lower case. After I enter the name in lower case & click "OK" the reponse is "You are about to update 0 row(s).". There is nothing entered in the table when I check it.
Can anyone tell me what I need to change to make the Query update the table with the uppercase name?
Thanks,
Yaani-Mai
View 8 Replies
View Related
Oct 13, 2006
Hello,
I have a table with data in Title Case (England) and would like to run an update query or a code to change all the records to UpperCase (ENGLAND). Can anyone help me? Thank you.
View 2 Replies
View Related
Apr 12, 2006
Hello friends,
I have data in my table field as "Orange" and some other entries in as all lower cases "orange", which really should be representing the same values.
Now when i use SQL in my modules to query and process this data, or create my report, it collects them as different values i.e. "Orange" is selected as one category and "orange" as another category, when really it should be getting them all (Orange, orange, ORAnge) as one category.
Perhaps this is a basic question, but everything i have tried doesn't seem to work. Can anyone tell me the best way to handle this?
View 6 Replies
View Related
