Make Part Of Default Value Bold?
May 26, 2006Is 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 Replies
ADVERTISEMENT
Can You Make Just One Part Of The Text In A Text Box Bold Or A Different Font Size?
Aug 20, 2004Is 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.
Make Text BOLD On A Report (criteria).
Feb 5, 2008Not 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
Modules & VBA :: How To Make Particular Text Field BOLD Based On Value From Query
Jul 20, 2015I 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.
Reports :: Text Box Make Bold Uppercase Text
Sep 18, 2014is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....
View 1 Replies View RelatedGeneral :: Make File Name Part Of A Field Value
Jun 13, 2013I'm trying to split up the filename into four separate fields. Here's an example of the filename:
123112 427900 55261 1156833.jpg
A 12312
B 427900
C 55261
D 1156833
The values A, B and C are always the same number of characters. The last value, D, changes in size. It can be anywhere from four characters to twenty. But it always starts at position "20" as with "1" in the case of the 1156833. The extension, jpg, is of no value.I might also add my programming ability is close to nonexistent.
Way To Make A Part Of A String That Is Calculated Into Currency Form?
Feb 28, 2012I have a text box and currently this is my control source
="Testing " & [test]/3
test = 1000 so my text box reports:
Testing 333.333333333333
Is there a way to make it into a form like $333.33...Also is there a way to make [test]/3 come out in a money text form? like "Three hundred thirty three dollars and thirty three cents.
Can Make Default Value Of A Field
Oct 10, 2012Can I make the default value of a field be something in another field in another table. I tried to enter into the default value the following but, it does not find the field.
[tablename].[fieldname] I also tried it [fieldname].[tablename].
Tables :: Make Default Value In One Field
Aug 13, 2013I am doing a project for school. I would like to make the default value in one field (available or rented) to be "rented" if the value in a field in another table is null. Is there an "easy" way to do this?
View 2 Replies View RelatedQueries :: How To Make Subdatasheet To Look Like Default One
Jul 2, 2015Linked field is shown both in Master and child tables, but not in the default subdatasheets made by when a relationship is made between a Master and Child Table.
View 5 Replies View RelatedGeneral :: How To Make Windows Default Navigation Work
Dec 17, 2013How do I make the windows default navigation work to the following:-Next record that navigates to next, but does not create a new record when at EOF. New record that creates a new record.
I've tried turning off 'Allow additions' for the form, but that turns off the 'New Record' button, so that's not right Perhaps it's me but the default way in which the navigation buttons work is strange. I would have thought the next button would only go next and wouldn't do new.
Shutter Bar - How To Make Default Closed Upon Database Open
Oct 26, 2012Is there a way to make the shutter bar be closed on database open?
I already have an autoexec macro to take people to a main menu, but would like to ensure the shutter bar is closed for aesthetics and to keep people away from clicking on something.
General :: Text Box On Form - How To Make Textbox Date Default To Previous Record
Nov 13, 2013I'm having trouble with a Form and getting a text box entry box (Date entry) default to the date entered on the last record, which is linked to a table.
The only way I can get it to work is to type the date into the Text Box's Default property, for example, #11/13/13".
How to get the correct syntax or code into the Default property of the Text Box to make this work? I only want the entry to change versus the previous record/entry if the User changes / enters a new date.
Tricky Question - Form Part Data Entry, Part Not
Dec 16, 2004I have what I think is a difficult problem to overcome...
I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.
Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!
If this is not possible, do you know how I can acheive this?
Thanks
S
Date Problem - Part Constant - Part Now()
Nov 3, 2006Hi everyone,
I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) )
However because the Leave Year starts at the 1 July and finishes 30 Jun I need to compose the date for any current year Year(Now())
Enclosed scrdmp shows my query design. I can easily get it to work as you see it, but obviously as each year rolls over, the year needs to change.
Have looked at many posts but can't find what I'm looking for. This one will get me over the hurdle.
Many thanks,
If A Make-table Query Result Is Null, How To Have A Default Message Appear In Table ?
Jan 21, 2005Hi everybody,
Beginner here needs help !
I'm building a make-table query for which if the result is null (no record correspond to the set of criterias), a default message like "there was no activity during the period" would appear in the table (not a message box...I need the message in the output table). The best I could think of is an IIF function but it doesn't seem to work... Is there any way to do this without using VBA?
Thanks in advance !
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?
Is There A Way To Display BOLD Texts In Msgbox
Jun 12, 2006Hi,
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
Is There A Way To Display BOLD Texts In Msgbox
Jun 12, 2006Hi,
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
How To Create A Message Box With Bold Text
Jul 11, 2012I 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
Bold Within Email Body Generated Within Access
Nov 21, 2006Hey, 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.
Coditional Format-Font Colour/Bold
Sep 22, 2004Greetings,
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.
Command Button Text Bold When Onfocus
Oct 1, 2004When 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!
General :: Bold And Underline Certain Text In Email
Nov 22, 2013I 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 RelatedBold Portion Of Text In Memo Field
May 1, 2012I'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?
Queries :: MS Access - Selected Query To Appear In Color And Bold
Mar 24, 2013I have this Access file with Tables & Queries.
I want selected queries to appear in RED colour and if possible BOLD too.
Possible ?