Bold Textboxes
Jun 29, 2005I 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?
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
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
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.
When 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?
I have this Access file with Tables & Queries.
I want selected queries to appear in RED colour and if possible BOLD too.
Possible ?
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 receive a bunch of excel files with items to be added to a database. some of the items are to be added as new, some to be deleted and others to be modified.
I identify the action (add/delete/modify) by looking at a column in the excel file e.g. column A.
At this point I am fine with the add/delete because I can filter the data or bring all the files to a temporary table in an Access database via vba script and then running queries to do the rest.
My issue is that the spreadsheets have a lot of columns and for the modifications what they do is use the same file for instance, make changes on the cells (any cell) that need modification and then highlight, bold or underline only the items that need modification and ignore the rest of the file (a tedious process since I have to then open each file and manually modify the database).
I would like to export from access a recordset into Excel and bold the column headers.
My current code works for the most part, except for the bolding.
You run the code in Access module and the code does the following:
1) checks to see if the excel file is open
2) if excel file not open, it opens the file, clears existing records, and starts copying and pasting new recordset into the RAW worksheet
3) it is then supposed to bold the column headers.
bolding is not working.
Code:
Sub TestFileOpened()
Dim lastRow As Long
' Test to see if the file is open.
If IsFileOpen("c: est2003.xls") Then
' Display a message stating the file in use.
MsgBox "File already in use!"
[code]....
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 RelatedHi,
I'm having some trouble with a report I am responsible for. I'm novice to Access, so if you could please explain in detail...that would be great.
Well, I am supposed to create a report, that will pickup data from 1 table (Passport_details), and display them in a report. Within the passport Details table, there are 3 fields (Scrap, Resale and RTS). For each record, their will only be a number in one of these fields. For example:
Product status: **here is where Scrap, Resale or RTS goes"
PassportID Product Scrap Resale RTS
123456 Battery 9 0 0
987654 Pots 0 7 0
456789 Knives 0 0 3
What I want is a textbox or label at the top that will state "Scrap" if there's a value other than 0 in the Scrap Field....."Resale" if there's a value other than a 0 in the Resale Field, and "RTS" if there's a value other than a 0 in the RTS field. There isnt occurences where their may be a value for two of Scrap, Resale or RTS...its either one of them.
I'm sure this is simple for the experts within this forum, but I could sure use the help.
Thanks,
Infamous
I need a text box in a form to display a series of error messages depending on the result of a DateDiff result, but I'm having trouble creating a single formula that encapsulates all error messages, but I have been able to get this working easily enough using 3 text boxes (For 3 seperate error messages one for results between 7 and 13 days, another for between 14 and 27 days and a third for 28+ days) and the same basic formula, I just need help combining them into a single formula for a single text box. I'm using these:
=IIf([DateDiff]>=7<14 and [Bleh] is Null, "7 Day Warning", "")
=IIf([DateDiff]>=14<27 and [Bleh] is Null, "14 Day Warning", "")
=IIf([DateDiff]>=28 and [Bleh] is Null, "28 Day Warning", "")
How would one go about combining all those formula's? I tried for ages today but I didn't come up with much, experimenting with Or IIf etc... but coming up with -1's all the time. Any help would be appreciated
OK, this is my first post and unfortunatly it is for some help...
I have searched Google to my wits end without any luck.
Heres my problem (partially) and I am hoping some kind person can help me.
Suppose I have a form [form1] and a query [query1].
On form1 I have a 2 textboxes. [txtProduct] and [txtStockCount].
Into [txtProduct] I enter the name of a product. In reality I have already a usable listbox in my form, but I am using a textbox for simplicity here!
Now I create an [EventProcedure] using 'On Lost Focus' against [txtProduct].
The event prodedure would partially read:
"SELECT query1.StockTotal, query1.Product FROM query1 WHERE = Product = txtProduct;"
In my actual form I am using a listbox with a listbox.rowsource = (SQL Query)to display the stock count, but I don't think this is the best way... (It works, i'll give it that!).
What I would ideally like to do is take the results from that aformentioned query and display them in txtStockCount.
What I am aiming for is to get the a query to dump its single result into a variable; not just for display purposes (txtStockCount), but to later validate user input when they wish to reduce stock values from the database, IE so they cannot produce negative stock counts.
I have a feeling this might involve Record Sets which I know nothing about at present.
If someone could either provide some working sample code snippet or point me in the right direction I would appreciate it.
I am confident enough to write SQL statements. I am semi confident in using VBA. (I am not a complete newbie).
If I have not been clear enough, I can provide a lot more information using actual details from the database I am trying to develop.
The database is a stock control system which records:
* products in one table
* transactions in another table (goods in and goods out)
* a query to 'sum' up 'goods' in and 'goods out' with an expression to create total stock counts for each item
* a form into which a user can select an item from the product table which would then produce a single count of the stock running another SQL query against the one already created to pick out that single product (phew!)
and finally in the same form add to the transaction table.
Here's hoping!
Damo.
I would like to use code to look at each field in my form (they are all textboxes) and if it is blank, fill it with "888". I have read enough to know I should use the NZ function, but can someone tell me how it should be written to look through every textbox on the form?
View 11 Replies View RelatedHy
This is maybe a question that has been asked a million times.
Can anyone explain me how you can link to textboxes in a access form.
I'm making a form that input info. When a user selects a number in the first textbox I want that in het second text box the info of that number is showed automatically. Those two (number and info) are in the same table.
And is this possible without using visual basic for applications?
Thx
I have a table with names of people and the cars they own. I made a form with a combobox which everytime i choose the name of the person in my combobox, it will list the cars they owned. That works fine. Problem i have is that i have to show how many cars they own. So i made a query to count the number of cars for each person. Then I made a textbox on the form to show this count. However I can't seem to link this textbox to the query since my form has a record source to the table of ppl and cars. How do i link my textbox to my query of counts of cars?
I tried changing the control source pointing to the field of the query but it doesn't work. I have linked the combobox selection so that my query filters to wat i select on the form. Anyone can help :( , its a simple process but i keep trying and doesn't work, and also dont wanna use a subform.
Hello all,
Thanks to all the folks that have helped with my posts in the past.
I have 2 questions.
I have a form with textboxes.
When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another.
Also, I have a textbox for memo. I would like to press enter and go to the next line in that textbox.
Thank you very much.
hi everyone,
i have a query which returns n number of rows. my problem is that i need to display the values in text box which is created automatically according to the number of rows returned in the same page(form).
for example if my query returns 1 row then 1 text box must be automatically created and then the value must be displayed and if my query returns 3 rows then 3 text boxes must be created and then the corresponding three values must be displayed.(on the same page).
is this possible?
aravind.s