Search results

David Thanks for your help - have been away for a few days but back onto this now. I'm was not sure what you meant by the 'description height' so I tried the following code in the Detail section 'On Format' event of my report: Dim SchemesTXTHeight As Single SchemesTXTHeight =...

Hello I have a report that displays information in a grid (see attached). I want to make the coloured boxes in each row match the height of the text boxes on the left (which have 'Can Grow, Can Shrink' properties) so that it displays more tidily as a grid. The coloured boxes have little or...

Thanks for replying When I try this I get the compile error "Method or data member not found" - any ideas? Code I've used is: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.FUNDING_RED = True Then Me.txtFunding.BackColor = vbRed End If End...

Hello I am working on a report which displays price information for each record in a table. I want to be able to vary the background colour of the report control displaying the price information depending on True/False values in a number of tick box fields in the underlying table. There are...

Worked a treat - thankyou. :)

I have a lookup table where each record represents a quarter of a year. An example would be 1 January to 31 March 2009 which would be called "Quarter 1 2009" in my table. In addition to this "name" field, the table also contains date fields containing the quarter start-date and quarter...

Bingo! Thanks for that - makes perfect sense. Saved me a lot of work! Cheers.

Thanks for replying. Wouldn't using that function just update the display text and not the underlying hyperlink address? I tried it before using the find and replace toolbar buttons in Access (which I assume do the same thing) but it didn't change the underlying address. :mad: Access...

Hello I have a database with a table containing a hyperlink field. The field is used to link to documents on our server that relate to the records in the table (there are thousands of records). The hyperlink value for a given record might be P:\Files\Springfield\Homer.doc as text to display...