Search results

Ok so the report is in rich text already. I am not exporting it to word or excel it is just visible in access and the users scroll down and read the report. is what your saying something i can add to the button code for the search so it auto highlights or is this a fix that I have to implement...

I can take the title out of the keyword search, Yes every field is rich text.

All except the Title field which is a short text

I am sorry your sentence is a bunch of gibberish to me LoL.

I was hoping to highlight just the keyword.

I have the following code in my database that searches through all my records for certain keywords and prints out a report that has each record that has the keyword in it. I want to highlight the keyword in the report to make it easier to find in each record. Is this possible? Dim dbCurr As...

well at least everything i did SHOULD have worked as intended, just a weird corruption. I will remake my main form and see if everything works.

my search code on the main form? to find the person? hmmm

thanks DBGuy, what did you do for the fix?

ok yeah it works now, what did you change other then the obvious visual changes?

It is set to data entry I do not want it to show data. It is supposed to be empty at all times and you input new leaves when they arrive. To view all of "Mann's" leave you click the button

if you open the soldier data form search for "Mann" and open the leave tab you will see data in the fields and there shouldn't be any data in there since its a data entry subform

ok I have taken all the personal data out

Sorry I tested positive for covid so i have not been to work to play with this database for the past few weeks. I removed the macro and did C&R and I am still getting information in my subform.

that was me trying to force it to be empty I can remove it.

This is soo weird then. I have no clue why my subform is showing data.

It has been set to yes back when i created it.

OK I don't think i have portrayed my scenario properly. I have From "Soldier Data" that is not data entry, has tabs and 1 of the tabs is Leave and inside that tab I have a subform "Subform Leave" which is data entry. I have set up Link Master Fields and Child Fields set to the DoD ID of the...

Awesome that time it worked thank you

that just comments out the line