473,770 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

First sign in a field needs to be a CAPITAL letter

First:
I have some troubles in access, some fields needs to begin with a Capital
letter.
Example: louiselaan need to be Louiselaan.
How can I become this?
Second:
I'm exporting my database to outlook. Than some names begin with a capital
letter some don't.
The name is always in capital letters in access and in outlook sometimes
it's capital sometimes not.
How can I correct this and make every Field just the same?
Nov 13 '05 #1
1 2674
"Marc Verdonck" wrote
First:
I have some troubles in access, some
fields needs to begin with a Capital
letter.
Example: louiselaan need to be Louiselaan.
How can I become this?
strCapitalized = StrConv(strAny, vbProperCase)

in code will capitalize the first letter of each word in strAny.

You can use the builtin StrConv function in code, in a Query, or in the
ControlSource of a CalculatedContr ol.
Second:
I'm exporting my database to outlook.
Than some names begin with a capital
letter some don't. The name is always in
capital letters in access and in outlook
sometimes it's capital sometimes not.
How can I correct this and make every
Field just the same?


See above. It seems likely that your data is being displayed properly in
Access because of the Format property of the Control in which it is shown,
but that it may be stored "as entered".

Larry Linson
Microsoft Access MVP

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
6033
by: Alan J. Flavell | last post by:
OK, today's email brought a comment from a reader, pointing out something that I'd long since noticed myself but hadn't done anything about it. On my pages, I've got a first-letter style on paragraphs. So far, so good: some of the paragraphs begin with a link, and there are styles in the stylesheet for link, hover etc. The first letter is still displayed as styled for the paragraph's first-letter.
3
5723
by: Marc Verdonck | last post by:
Hello, 1. I received a mail from Larry but it doesn't work, I'm not a programmer. How can I simply make a field (street) begin with a capital letter in another field (adress) everything capital letters? 2. I have all adresses in access and make conversion to outlook. How can I provide that the fax is also been seen as an email adress. Regards,
43
2813
by: Roger L. Cauvin | last post by:
Say I have some string that begins with an arbitrary sequence of characters and then alternates repeating the letters 'a' and 'b' any number of times, e.g. "xyz123aaabbaabbbbababbbbaaabb" I'm looking for a regular expression that matches the first, and only the first, sequence of the letter 'a', and only if the length of the sequence is exactly 3.
7
1851
by: AA Arens | last post by:
I want to fill in data in the fields and the first caracter is now automatic capitalized, however, I do not want this as abbiviations must be fully in capitals. How to get it? Bart Acc 2003.
1
3048
by: Simon | last post by:
On my access forms when i enter text how do i automatical get it ti change the first letter of each word as a capital and the rest of the work in lower case. I want to do this as when i write in customer adress i want it to to change it automaticaly Hope someone can help
4
3689
by: robert.szczepanski | last post by:
Hi everybody; I can't change polish sign to small letter. This is my php script: <?php setlocale(LC_ALL, "pl_PL.UTF-8") ; //this function return "pl_PL.UTF-8"
11
45249
by: =?ISO-8859-1?Q?Konrad_M=FChler?= | last post by:
Hi, a simple question: Which standard function in c++ gives me the sign of a number? Thanks Konrad
3
5040
by: dmalhotr2001 | last post by:
Hi, For string extraction function in vb, if I feed in a paragraph, how do I extract the first sentence of that paragraph. Thanks :D
4
5571
by: zcabeli | last post by:
Hi all, i'm currently struggling to perform the above mentioned replacement. i already know how to catch the first letter in each word and determined if it's regular or capital. however, i don't know how to replace this letter with it's corresponding capital letter. perhaps there is an option to change the ascii value of the a character in perl regexp ? for example :
0
9618
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10260
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10101
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9906
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8933
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6712
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4007
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.