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 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.
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.
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:
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!
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?
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.
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
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?
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......
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......
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.
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?
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!
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!
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
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)
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
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.
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.
