Make All Text Caps

I need to make all my text in all my fields Caps.
The users want type the text in the field and have it be caps even if they don't have the caps lock on.
Is there an easy way to do this?
Any help would be great!

View Replies


Make It All Caps - Version: 2000 (9.0)

I have an unbound text box with the following Control Source:

="SHIFT SCHEDULE FOR: " & Format(Date(),"mmmm yyyy")

How do I make the month show in Caps as well. I tried MMMM but it changes to mmmm (I thought I would try the simple thing before asking).

View Replies View Related

Convert ALL CAPS To All Caps - Version: 2002 (10.0) XP

I'm looking for an "Update To" procedure that will take all records in a table and convert them to their proper case.
For example if reads...CARSON CITY , will convert to Carson City
Or SIOUX CITY IOWA, Sioux City Iowa
is this possible ?

View Replies View Related

Can You Make Just One Part Of The Text In A Text Box Bold Or A Different Font Size?

Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?

Something like this:

Heading in bold: description in regular (not bold)
(a smaller height line used as a line space)
Another "normal" line
a larger height line
a normal line....all in one text box!

One thing I'd like to be able to do is to specify the line height of a blank line in a text box. I'm using carriage returns created with: Chr(13) & Chr(10). I could see defining the font size of a hidden character, but I'd need to know how to assign a font size to a piece of the text in a font box.

View Replies View Related

Caps Lock

How can I convert the lower case data into upper case data automatically while entering data without using Ucase() function, in each and every textboxs or other objects in the forms ..

View Replies View Related

How To Make Text Box Appear?

I haven't used Access in a looooong time and building a document tracking database for work. I am setting up my data entry form and would like to have a text box appear depending on the selection from a combo box. So, if the user selects "In Review" a text box will appear for entry of the reviewer's name, likewise if the user selects, "In Work." In the other cases (options in the combo box) the document is not being revised, so no name needs to be entered--so no need for the additional text box. Make sense? Any guidance/advice as to how to go about this? Thank you!

View Replies View Related

Returning Caps On A Form

Heeelo all:

I have a form with text fields where I am entering customer last names and first names in different fields. Does anyone know how to return UPPER CASE letters automatically?



View Replies View Related

Initial Caps - Version: 97 (8.0)

Is there an initial cap function?

View Replies View Related

Combo - LimitToList Small Caps.

I have a combo with the LimitToList set to yes so I can add new data to the underlying tbl. This works fine with one exception. When I enter the data I occasionally want to enter it in all Capitals but when I select Ok to add it to the tbl the first letter is a capital & all others change to small caps. I'm a little rusty on Access at the moment so I need a prompt pointing me to what I need to change to fix my problem. I'm thinking this is a formatting problem? :(

View Replies View Related

ALL CAPS IN A TABLE - Version: 2003 (11.0)

Is there any way to change entries in text fields to ALL CAPS using an append query? The table already has entries, but for the sake of consistency, I would like to make everything all caps. Some are normal and some are all caps. Want to make them the same.

View Replies View Related

Force CAPS? - Version: 2002 (10.0) XP

This is probably simple, but I'm drawing a blank. I'm writing a database at work that needs to store codes that use alphanumeric and special characters, but the alpha characters can only be capital letters. Is this something that can be accomplished via a macro, VBA, a setting on the forms (cannot figure out which would do it if that's the case), or not at all. It's easy enough to hit the CAPS LOCK key, but many folks aren't good about remembering to do that.


View Replies View Related

Using Date And A Value To Make A Text Box True

Hey all, i got another small problem with this bloody database!

The problem today folks is this, im making a booking system (well the booking is a small part of the overall system) so i have DateArrive, RoomID, and all the usual.

now what i want is to make a query that says
if DateArrive & RoomID (Booking Table) then make RoomOccupied(Room Table) true

if that makes sense, i tried some in sql and got the date bit working, but wasn't sure how to go further so as to make it so RoomID is involved

(ill say in another way If a room is booked on a specific day i want to make Occupied true)

thanks for anymore help u can give

View Replies View Related

Make A Text Box Visible On Cmd Button

Hi, I have a form with a INFO button, what I need is when the info button is pressed a text box becomes visible on the form and when pressed again the text box become not visible, this will allow the final user the have additional information regading compiling the form etc!

View Replies View Related

ALL CAPS Conversion From Excel - Version: 2003 (11.0)

I am working on my certification in Access and ran across a potentially magical tool, but as yet have been unsuccessful in implementing it.

I have many times received Excel spreadsheets of mailing lists with all the data in ALL CAPS and it makes the list visually undesirable when mail merging them later. I just learned about "input masks" and was delighted to think that I could set up the following mask that would fix the ALL CAPS spreadsheets:


When I input data the mask works just as I would want it to, but when I import data, nothing happens to the already existing ALL CAPS data. Is there any way to utilize Access to automate the conversion of proper names and other data?

View Replies View Related

Changing A Field To CAPS - Version: 2002 (10.0) XP

I have a title that in one report the month should appear as CAPS and within another report it should not appear with CAPS. Is there a way within a query to tell the field month to appear with caps?

View Replies View Related

Make Table To CSV, Remove Text Qualifier

Thanks for looking!

I'm using a query to export a table to a text file, i.e.

SELECT * INTO [Text;HDR=No;Database=C:].[test#txt]
FROM [TestTbl]

Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL (similar to how HDR=No gets rid of the headers)?

I've tried searching and guessing, but nothing has worked yet. Thanks!

View Replies View Related

Can Selecting A Combo Box Make A Text Box Visible Again

Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.

Thanks any help with be greatly appreciated

View Replies View Related

How To Make A Button That Autofills Text Into A Form?

I have a database form where I have a lot of like data I type.
Can I make buttons to automatically put text into the form field?
How do I do this?

View Replies View Related

Can Selecting A Combo Box Make A Text Box Visible Again?

Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.

Thanks any help with be greatly appreciated

View Replies View Related

Make Text BOLD On A Report (criteria).

Not sure if this is possible but here goes (even if I make a fool of myself for asking).

I have a report that lists data based on criteria set in a form. The main criteria is Month (Month4Report) and Year (Year4Report).

The report lists all jobs that started that month and also any jobs that had work done during that month - even if they started in the previous month.

What I would like to do is highlight any job that has an actual start date prior to the current searched month (Month4Report). By making it bold or other way.

Is this possible?



View Replies View Related

Make A Text File - Version: 2003 (11.0)

I'm still having issues. I need to make a text (.txt) file for the data that is entered, but it can't have any quotes around needs to look like the below:

either like this
881,324922,L,KURT,JIM,,9901 E 54TH ST,TULSA,OK,74112,,DL,OK,08939231,,09/10/1954,M,W,11/12/2007,08:59,1,MISC MNS RING,,,,Y/G,PRING,8

or like this:

30301|295559|LOAN|LONG|SHAME|LARRY|1197 S. 856TH W. AVE|TULSA|OK|74127||1|OK|081461430||073054382|F|W|11122007|907| 2|Laser Transit|BOSCH|DLR165|784675561|Green|ETRANSI|

This is what I have...but it keeps putting the quotes...any help would be appreciated!!! Thanks.

Private Sub Command0_Click()
DoCmd.TransferText transfertype:=acExportDelim, _
specificationname:="Contacts Export Specification", _
Query:="qryData and Shop", _
FileName:="c:deletepawnshop.csv", _

End Function

View Replies View Related

How To Make Validation Text Give Different Error Messages

In of my tables called Employee Payroll, I have several earnings fields, and in a previous post I mentioned that I have implemented a validation rule for them which is 2.50 or 2.75 or 3.10. I have also used an error message in Validation Text to help the user if they enter an invalid value.
How can I change this message to reflect what the user types in? For example, if they enter an erroneous value like 9.34, the error message would say, "You have entered an erroneous value" or if they type an extreme value like 3.40 or 0.01, the error message would say, "You have entered an extreme value".
I understand that I would need to state when the data becomes erroneous and when it becomes extreme- so I thought, anything above, 4.00 should be erroneous and any negative values too. Extreme data would be anything between 0.00 and 3.10.
Would I need to use some kind of code in VBA?

View Replies View Related

Make A Records Text Bold & Red - Version: 2003 (11.0)

Is it possible to make a single records text red and bold if a control meets a certain criteria in a VBA statement?
here is my code as of now, just to make the text bold, I would like it to be red also, but it does nothing to the text in the record after the statement fires.

If Me.D0010 = 17100983 Or Me.D0010 = 17103979 Or Me.D0010 = 17104035 Or Me.D0010 = 17104043 Or Me.D0010 = 17104050 Or Me.D0010 = 17103656 Then
MsgBox ("This Is A FirePlace, Must Call For RGA, No Return To HHH")
Me.D0010.FontBold = True
End If

Me.D0010 reside in a subform of a Parent Form. It is the Control with the red arrow in the attachment

View Replies View Related

Trying To Make Rport Text Bold Via Vba - Version: 2000 (9.0)


I have a report which on a certain condition being true I want the text for that record to be bold, I have placed the code below in the On Page event of the report, unfortunately nothing happens i.e. the text does not become Bold.

Clearly I am not doing this correctly, can someone give a clue please.

If Me.OnMatLeave = True Then
Me.sLastName.Font = Bold
End If



View Replies View Related

Set Data Format To Initial Caps In Labels - Version: 2000 (9.0)

I would like the data for labels to have initial caps; e.g., "Theodore Roosevelt", instead of 'THEODORE ROOSEVELT" or "theodore roosevelt". =Ucase(Mid([first name},1,1)) & Lcase(mid([first name},2)) works for only the first word and disregards the following words; e.g., 110 Apple Lane comes out "110 Apple lane. Does anyone know the correct way to print address labels, or file folder labels, with initial caps?

View Replies View Related

How To Check Text Box To Make Sure It Is Filled In Correctly - Version: 2007 (12.0)

I have a form that let's a user enter in a date using format yyyymm example: 200705

I want to make sure that 6 numbers are always entered into the textbox, or else pop up an error message. Can someone point me to the right direction as to how to do this?


View Replies View Related

Basic Commands - To Insert New Line, Make Text Bold, Etc.

Dear all

I need help with a silly thing as i do not know the code commands for VB.

I am using access to send email using outlook. I have written code etc, and everyyhing works fine. Now i have got olitem.To = "", olitem.CC = "" , olitem.subject = "employee details". Everything uptill here works fine. I need bit help with olitem.body. Below is the format i want to appear in the message box of outlook, but i dont know how to create a new line, insert a paragraph, make text bold, have indentation, etc in this body. Does anyone have knowledge about this.


Dear Administrator
The Employee (Name):
Job Title:
Employment Start Date:
has requested for the holiday form to be sent to at

Email sent from the intranet.
Please do not reply to this email

I just know how to write a simple straight line using code:
olitem.body = "Dear Administrator The employee " & Me.txtForename & " " & Me.txtSurname & "has requested....."

Thank you in advance

View Replies View Related

How To Make A Body Text Of An A Coded Message In Automated E-mai - Version: 97 (8.0)

I had managed to create code for sending e-mail with a standard message normally to send periodical reminder, however the resulting messsage will be shown as a long word with no proper paragraph. I would like the message to be well structured and properly paragraphed and if possible it would also have a footnote that read :" This is a system-generated email".

Basically the bodytext I would like to have is as follows:

<Mainbody text>

Thank You

This is a system generated e-mail

Is this possible.

Any suggestions is warmly appreciated. Thanks.

View Replies View Related

Trying To Make A Combo Box That Show The User Text While Storing - Version: 2002 (10.0) XP

I have recently revamped my database to achieve Normalization (I think). Before I used tables with one field as related lookups. Now I am storing a code in the main table and most of my simple lookup tables are not related in the relationship table. This solved my problems from before with queries, but now my lookups are needed since the code is not detailed enough for the users to count on.

I would like to hide the code from the users and show them the whole text intended to be stored. I am using a form with a combo box. How can I show the user "text" while storing a codenumber in the table?

AutoNum PK (num)
HerbDate (date)
SiteID (num)
ManagementObjID (num)

ManagementObjID PK (num)
ManagementObjective (text)

I have figured out how to make a 2 columned combo box that shows both the ID and the Text. It saves the ID code on the form. Is there a way to show the user the Text on the Form while storing the ID code in the table?

View Replies View Related

Newbie Question: Syntax To Make Text Clickable - Version: 2003 (11.0)

I know this is a basic question, as I was unable to find it on any of the previous threads. I have a list of students in a subform. I want to be able to click on a name on the subform (Key) and open a separate form with the details of the specific student on it. I know it sounds simple, but I just don't have the programming expertise to build this. Any ideas?

View Replies View Related

Make Text Box Invisible If Group Value = "Pending" - Version: 2003 (11.0)

I've tried several things for this one, but no success.
I would like the textbox in the detail section to be invisible if the group value = "Pending".
Any thoughts?

View Replies View Related

Make A Field From Text In A Memo Field Help Needed - Version: 2002 (10.0) XP

Can someone hopefully suggest a method to extract a certain line of text from a memo field in a table.
I have a database which has a linked table to Outlook. I have created a table which selects just the two fields from this linked table which are needed i.e. Created and Contents
The body of the email goes into the Contents field which is a memo type. This is all okay for my use.

The emails are from a web site by users completing an online form. They always follow the same format.
What I need to be able to do is extract a line of text from this memo field and create a seperate control on a form so they can be indexed.

The email always has the following:
Event = 1 (This number can change)
StaffNbr = 1000 (This number also changes and is the unique number required to be extracted)
The email then contains several other items and text but I am not concerned about these items.

Whilst the field in the tables "Created" is probably unique indexing/ searching on that is not practical as it is the member of staff that needs to be searched for.


View Replies View Related

How To Force Characters Entered Into All Caps? - Version: Any Version

Hi, I have a txt box wherein a user enters and ID like XA000065949 or TA00006666

Without making them do anything I wan't the alpha characters to always go into the db as CAPS.

Do I need to write a function to do this or is there already one built in that I've been missing?


View Replies View Related

Copyrights 2005-15, All rights reserved