Make Text BOLD On A Report (criteria).

Feb 5, 2008

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

View Replies


ADVERTISEMENT

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

Aug 20, 2004

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 2 Replies View Related

Reports :: Text Box Make Bold Uppercase Text

Sep 18, 2014

is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....

View 1 Replies View Related

Modules & VBA :: How To Make Particular Text Field BOLD Based On Value From Query

Jul 20, 2015

I 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.

View 5 Replies View Related

Make Part Of Default Value Bold?

May 26, 2006

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 Related

How To Create A Message Box With Bold Text

Jul 11, 2012

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

View 5 Replies View Related

Command Button Text Bold When Onfocus

Oct 1, 2004

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!

View 3 Replies View Related

General :: Bold And Underline Certain Text In Email

Nov 22, 2013

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 Related

Bold Portion Of Text In Memo Field

May 1, 2012

I'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?

View 1 Replies View Related

Forms :: Datasheet View - Change To Bold Column Text

Apr 20, 2014

Is it possible to change to bold font the text column of a datasheet view?

View 3 Replies View Related

Reports :: Choosing Which Report To Run Based On Text Box Criteria?

Nov 10, 2014

I have a form with a command button that runs a report. I have been asked to modify things and if the data in the text box is "A", run report "A". If the data is "B", run report "B" and so on.

View 3 Replies View Related

General :: How To Make A Report Using Crystal Report Direct From MS Access Form

Jun 3, 2014

I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "

how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error

Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work

View 2 Replies View Related

More Than Three Conditional Make-up Criteria

Dec 9, 2005

Hello,

I've got a continuous form containing more than one record (5 to 30). I present the data of these records in text boxes. I need to color the boxes according to the data that they contain. This means that the same field can have different colors in different records. The total number of colors that is about 8 (correspondending with 8 different codes that can be in the data fields behind the text boxes).

Normally I would use Access standard conditional make-up function to implement the functionality described above. However the limit on the conditionl make-up criteria for each field is three (also if you use the formatconditions object in VBA) so that is not sufficient in this case. Is there any way to add more than three conditional make-up criteria to a text field?

Any help would be very much appreciated.

View 1 Replies View Related

Check Box For Criteria In Make Table Query

Jul 29, 2005

having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relavant 'ticks' across............ and how the hell would i do that......


many thanks in anticipation......

View 1 Replies View Related

Check Box For Criteria In Make Table Query

Jul 29, 2005

having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relevant 'ticks' across............ and how the hell would i do that......


many thanks in anticipation......

View 2 Replies View Related

DLookup To Display Date In Text Box On A Tab Control Where Criteria Is Text Field

Apr 15, 2014

I'm trying to pull a date from a table into a text box on a form tab control using DLookup and I just can't figure out what is wrong with my DLookup expression:

=DLookUp("DateOrdered","tDateOrdered","PrNumber=" & [PrNumber]) ----- (DateOrdered is short date, PrNumber is text, db is split Access 2013)

Whats missing in this expression? I've tried every criteria variant I could find but to no avail.

View 9 Replies View Related

How Make Query Criteria Come From Selected Records On A Listbox

Mar 15, 2008

I have a form which contains a listbox. It is a multi-select listbox. And I have a button on the form which runs a report. But I want the report to only show the selected records from the listbox. The report gets its records from an underlying query. But how do I make the selected records on the listbox become the query criteria?

View 4 Replies View Related

How To Make Text Box Appear?

Aug 30, 2005

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 3 Replies View Related

Bold Textboxes

Jun 29, 2005

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?

View 4 Replies View Related

Make All Text Caps

Aug 30, 2005

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 5 Replies View Related

Special Report I Need To Make

Jul 27, 2006

Hi, I'm running Microsoft access version 10 and i need help with a report i need to make. I need to print out a roster report showing what students show up on what days. I have boolean variables in the table for each day and it is quite easy to make a report of the students i want with the days of the week and a check under which day the student comes in. What I want however, instead of a check to show up under Monday (or any day) for the students, i want that students name to appear. So i teacher can just go down the list and on any given day see the students names very easily. when a student does not show up that day that row and column can just be blank

Here is a very crude sample of the report a have. a slash is a check

Monday Tuesday Wednesday
Jack / /
Brian /
Kelly / / /

Here would be the exact same report but formated the way i want it

Monday Tuesday Wednesday
Jack Jack Jack
Brian Brian
Kelly Kelly Kelly Kelly

thanks for any help.

Keith

View 1 Replies View Related

Using Date And A Value To Make A Text Box True

Mar 27, 2008

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 6 Replies View Related

Make A Text Box Visible On Cmd Button

Aug 27, 2006

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!
Thanks
Marco

View 5 Replies View Related

How To Make Text Clickable In MS Access

Jul 23, 2012

How to make the text clickable (and will open a new form)

for example

StudentNo

12345<---- if i click this one 12345 information such as name, age, course, year and etc. will show in a newform
12346
12347
12348
12349
12341

View 3 Replies View Related

Is It Possible To Make Long Text Longer

Jul 4, 2014

I have a large spreadsheet with one column of information which is longer than what access accepts as long text. So when I convert the spreadsheet to access all the large boxes of information are shortened so that I am losing a lot of information.

View 1 Replies View Related

How To Make A Text Box To Retain Its Previous Value

Aug 10, 2014

I have a text box in a form. When the value in the text box is changed, a message box appears asking if the user wants to change the value in the text box. If they select "Yes", all is good and it goes on well, but when they select "No" is it possible for the text box to retain its previous value?

For example.

The value in the text box is "1". The user changes this value to "2". A message box pops up asking if the user wants to change the value, the user select "No" and so the value in the text box goes back to "1", the number it started with before it changed.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved