473,405 Members | 2,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

how do I make it so last letter of each word in the same field is capitalized?

1
I have a test and one of the questions can be the upper one, i just have to write the formula for it in the Design View as >L<???? for the First leter capitalised but i need the oposite one the last letter Capitalised, hope that you unterstood.
Mar 10 '19 #1
1 972
twinnyfo
3,653 Expert Mod 2GB
Albi,

Welcome to Bytes!

I see you are talking about input masks. I am not sure there is a way to do that with input masks unless you know exactly how many letters the input string is. That is, if you know that the input string is eight characters and only eight characters, you could do this. However, if the string is a random length, you would have to examine the string after the fact, and change the last character. You would have to determine the ASCII value of the last character and then adjust accordingly. You would adjust that character by subtracting 32 from its ASCII value.
Mar 10 '19 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: Nige | last post by:
To save me re-inventing the wheel, does anyone have a function to capitalise each word in form data? I was thinking along the lines of capitalise the first letter of the string, then any other...
2
by: Peter McKeown | last post by:
I want to write letters to people in my database. I have a field Surname and a field FirstNames. How do I get the first letters of each word in FirstNames? For example: Surname "Bloggs" ...
1
by: Dwight Shubert | last post by:
Hi all, This is my first try using Access. I understand how to format a text field for uppercase and lowercase, but how do you capitalize only the first letter of each word? tia Dwight
5
by: Rotor | last post by:
Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized? Thxs.
11
by: adamjblakey | last post by:
Hi, What i want to do is make the first letter of each word in a sting uppercase except "and" & "in" How would i go about doing this? Cheers, Adam
4
by: kobe67 | last post by:
Create a program that will ask a string from the user, your program should automatically exchange the 1st & the last letter of every word in the string
5
by: Russell Melmed | last post by:
I have been struggling with this one for some time now in Access 2003, so I'm reaching out for answers. I am trying to auto-populate an ID field in my form using the first character in each word of...
1
by: Jess Rubio | last post by:
I am having problem regarding on how would i create a store procedure that can return only the first letter of each word on a data. ex. Community Service the return data must be CS. how would...
5
by: ggftw | last post by:
Hi, I have a field named CustomerNRIC and have an input mask of L0000000L. I need a code ( at OnEnter I assume ) so that when I enter the IC, the first letter must be either "S" or "T" and the last...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.