Recent content by sjassal

Hello, On a given condion I would like to change the font color in the detail section. How can I accomplish this? I am able to make a field visible and not visible using Me!objectName.Visible = true. How can I access its font color? Thanks for your help in advance.

Figured out a different solution End of post.

Figured out a different solution End of post.

Hello, I have an idea how to do this but do not know how to write the code. In a report I would like to do the following: I have a key_id which is a hidden field on the report. For each record I would like to check the count of that key in a temporary table. if the count is 0 then I want to...

Hello, I am not sure if this is possible but if it is any help or suggestions will be greatly appreciated. Lets say I have a record that falls in 2 or more categories. I would like to mark (change the font color) for the repeating entires. For example: Table A code name...

I got the problem to be fixed. I needed a patch. For reference here is the link to the path: http://www.microsoft.com/downloads/details.aspx?FamilyID=AF6C8D03-7633-45B4-AB96-795EE656F2A2&displaylang=en

Hello, I have a report that is made in landscape view with margins set to be .5 for left and right. Once I open the database and click on a button on a form that opens the report it displays fine. But problem start to arise after I close the report and click on the button again. The report...

Hello, I would like to know if there is a way to insert page breaks depending on the output. Lets say I have a memo field on a report and under that i have a static table (Just lines with some fields so it looks like a table, NOT an access table). now what I want to do is if memo takes up...

Thanks Thank you so much that worked

Hello, I have been working on a database which started out to be 7MB. I added some reports and some more queries to it and eventually it got to 8.5MB which was reasonable. The problem started arising when in one of the queries I omitted a column, the database size just shot up to 13MB and then...