I want to create a message box with bold text
Ext:
MsgBox "1. Hello!" & vbCrLf & "2. How are you?" & vbCrLf & "3. See you again!", vbInformation, "Message"
Result:
1. Hello (this line is bold)
2. How are you?
3. See you again
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.
is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....
View 1 Replies View RelatedWhen a command button is onfocus, how do I make it bold or a different color and when it's not onfocus to return to it's default format? I know that this is possible with text boxes but I don't know how to do it with command buttons.
Please help. Thank you!
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?
Thanks.
Martin
I have created an automated e-mail quote for a client database. I have created several strings that make up the body text for the e-mail (some with info drawn from the database fields). Is it possible to have certain strings underlined and bold face? How would I go about that?
View 5 Replies View RelatedI'd like to set the value of a memo field on a form so that part of it is in bold. For instance, I want to say:
[memo_control] = "This is not bold" & "this is bold" & "this is not bold"
How do I do that in VBA?
Is it possible to change to bold font the text column of a datasheet view?
View 3 Replies View RelatedI am using MS Access 2007 and have a report which display the list of values (say 10 fields) from the basic SELECT * FROM table query.
I need to dynamically set the BOLD based on the particular value for the fifth field which was assigned from Query. if it doesn't match it should display normal.
E.g
If Field_5 = "Agent" then
Field_5.FontBold = True
Else
Field_5.FontBold = False
End if
I tried the aforementioned code and it dont work. ALso i tried achieve it using below listed options.
Me.Field_5.FontBold = True
Field_5.Properties("fontweight") = 700
But nothing worked.
I have done some serious searching and have discovered that many others have posted this question, but I couldn't find any satisfactory answers.
I have a FE/BE Access 2000 database in a multi-user environment. I have my default record locking set to "No Locks" (optimistic), but for unknown reasons, some records still lock. The records are viewed via a form, which is also set to "No Locks." We only have about 20 users, so it is rare that two people actually have the same record open at the same time. It seems to be that whole groups of records lock sometimes, despite the fact that I'm using optimistic record locking. Usually if you wait 15-20 minutes it is unlocked. If someone can explain this I would be overjoyed.
But, I can deal with the record locking. The problem is that users have no idea why they can't update a record and no matter how many times I tell them to wait 15 minutes they still come crying to me every time. So, I want to make a message box pop up when they try to update the record that states something like this: "The record is currently locked. Please try again in 15-20 minutes."
If someone could offer some code options and explain where it needs to go (form load, open, etc.) I would be eternally grateful.
Thank you!
I have created a command button through the wizard that is basically:
DoCmd.GoToRecord , , acNewRec
Well, it puts all this code in the event:
Private Sub NewVerification_Click()
On Error GoTo Err_NewVerification_Click
DoCmd.GoToRecord , , acNewRec
InboundQuestions!Page1.SetFocus
VerificationNo.SetFocus
Exit_NewVerification_Click:
Exit Sub
Err_NewVerification_Click:
MsgBox Err.Description
Resume Exit_NewVerification_Click
End Sub
Well, my PK field is one users enter in manually (please don't ask why). What I need is something that checks to see if the number in that field is a duplicate key, so I can tell users via msgbox "Duplicate Number, try again". Right now, it's not that descriptive, it says "You can't go to the specified record". I guess all i need is an If statment, but I don't know the code that checks to see if [field1]'s value has already been used in my table. Any ideas?
access where in on clicking a button on an access form, I can insert Field A, B & C (all containing email ID's) in to a new mail message in outlook. Similarly I have a subject field which needs to go into the new message as subject.
I enter data into the table using the form where the button needs to exist.
I'm creating a DB that includes a form that "Customers" will fill out. The form (CustomerForm) has text boxs that must be completed. I'm trying to figure out how to make sure all text boxes are filled out. I have already created a Input Mask and selected Required in the "Customer" Table. There is also a Username text box I would like to have validated that is is not already being used and two password text boxes I would like to have validate against one another to ensure it was created correctly. Once all text boxes are properly filled out I would like the Button to Save customer data, close CustomerForm and Open ShoppingCart. This is the code I have created:
Code:
Option Compare Database
Private Sub Log_In_Click()
If IsNull(Me.CustomerFName) Then
MsgBox "Please Enter First Name", vbInformation, "First Name Required"
Me.CustomerLName.SetFocus
[code]...
Is it possible to create 3 custom caption buttons for a message box?
I know I could do this as a form, but would like to know if it can be done in vba using msgbox...
In MS Access form, how can I create my own message if the user enter a value that not match with the data type of a field in underlying table? Thanks a lot!
View 3 Replies View RelatedHow to create a message when no records are found from a form to a query in the report.
Example; Donations From Great Britain have no records
I have a form and when it's opened you get 3 different search questions to answer or leave blank. My question is.... If a search parameter is entered but no results are found to match it, how do I create an error message telling the requestor "No Data Found"?
View 7 Replies View RelatedI need to create a message box or a form or something to flash on the screen to tell the user that a piece of "Update" code is running. the update code will be updated reports from marketing returns, but the 3 branches who use the information are separate so I am creating an update form to download and update the table.
The code for the update is already working, but can take a while, so I thought a message or splash screen would be useful as the update runs on start up.
It would have another use, I have a report which is made mainly of calculated fields on an onPrint event and also takes a while to work it out, so a similar screen would be more useful than my current spinning circle and blank screen.
Hi I wonder if someone can help me with this.
I have an access database in which there are tab controls to collect text written about a subject. My problem is that there are nine tabs all with the exact same code behind them, but obviously varying object names for the relevant text boxes. Four of them work as expected and five don't.
The following code has been used to display a popup if the user types too much text and it works for the Environ_Plan text box:
Private Sub txtENVIRON_PLAN_Change()
Dim strMessage As String, varLen As Variant
varLen = Nz(Len(Me.txtENVIRON_PLAN.Text), 0)
If varLen > 250 Then
strMessage = "You have exceeded the limit of this field by " & (varLen - 250) & " characters." & vbNewLine
strMessage = strMessage & "The maximum allowable length is " & 250 & " characters."
MsgBox strMessage, vbOKOnly + vbExclamation
End If
End Sub
(note that if the user types 251 characters an error message appears on the screen to say they have exceeded the number of characters allowed for that box and they cannot type any more text.)
The following text is used for the exact same outcome in Health but it does not work:
Private Sub txtHEALTH_PLAN_Change()
Dim strMessage As String, varLen As Variant
varLen = Nz(Len(Me.txtHEALTH_PLAN.Text), 0)
If varLen > 250 Then
strMessage = "You have exceeded the limit of this field by " & (varLen - 250) & " characters." & vbNewLine
strMessage = strMessage & "The maximum allowable length is " & 250 & " characters."
MsgBox strMessage, vbOKOnly + vbExclamation
End If
End Sub
(In this case the cursor stops and the user cannot type any more text but no message appears to say why the cursor has stopped.)
I have double checked the actual variables in the Access database and they are set to the exact same values.
I am using Access 2002 on Windows XP Professional.
thank you in anticipation.
Ouma
I've now got my database firing off SMS text message.The only thing I'd like to improve would be the body of the text.Right now my code for my message is
Message = "Hi"
I'd like to incorporate some fields to speed things up so I could have things like..
Message = "Hi" [Customer Name]".
I currently have a if statement checking for values greater than 0
if(x>0) Then
Statement
Else
EndIf
Is there a way for me to set the property Bold to the text box in the case that x >0?
Is there a way to make only part of the text in Default Value to be Bold or Italics? That would be cool so I dont half to make boxes throughout my paragraph for only bold text! :cool:
View 2 Replies View RelatedHi,
Anyone of you have idea how I can make my texts bold or colorful or place smilies while displaying the msgbox ?
I don't know if there is a way to do this. But if there is, it would make a diferent look.
With kind regards,
Ashfaque
Hi,
Anyone of you have idea how I can make my texts bold or colorful or place smilies while displaying the msgbox ?
I don't know if there is a way to do this. But if there is, it would make a different look.
With kind regards,
Ashfaque
Hey, I was wondering how I would tell Access to set bold on my email message. I use this code to generate the email:
Private Sub Email_Click()
strToWhom = [EMAIL]
strMsgBody = "This is my email body, I would like this word bold"
DoCmd.SendObject , , , strToWhom, , , "Subject", strMsgBody, True
End Sub
Thanks for any help provided.
Greetings,
Having got my database working, my manager has thrown a spanner in the works.
We have certain employees with the same grade as others "BUT" they have been given a "privilage".
I have put a true/false field in the table and in the report I would like, if the field is true, to print the last name in red or bold for instance.
My report is based on a query, from several tables.
If this can be achieved where to I do the code or whatever,
the table, query or report?
Have searched the forum but couldn't really find what I need.
Any help will be most appreciated.
Thanks,
Brian.
Zimbabwe.