Recent content by ahdkaw

More researching later... From what I can tell, this is a bug in Access 2000, as at every point in the processing of the data, it is not truncated. It's only when that data is placed on the report that it becomes truncated. So, I have only one option left to me. I can explain it better if I...

After a bit more investigation, I have found something weird... If I take the original data from the query (ie: tblCategories.Details), then the entire memo is correctly displayed within the textbox. However, this is no good for me, as I need to remove the carriage returns and line feeds...

Hi, I have an Access 2000 report which pulls a memo field from my database and displays it within a textbox control (CanGrow enabled), however I have discovered, much to my dismay, that the field is being truncated to 255 characters. Now, I have read somewhere that the Report Textbox control...

Karl, After trying your suggestion, it seems that my code will still NOT break on ANY breakpoints I set in my code... My hair is getting thinner by the minute...

Thanks Karl, you just solved a problem that I've been suffering with for well over a month! After posting the same question on about 4 different forums, you are the only person to answer my query. Once again, many thanks, now I can carry on my development. Regards, Ahdkaw http://sensibilium.com

I'm working in Access 2000, and I'm trying to debug my code using breakpoints, but ever since splitting and deploying the database (I am still developing in the original db), it refuses to stop the code at any breakpoints I put in my code! I have tried every Error Trapping setting in...

I have a Purchase Order form which has a subform for Purchase Order Details. I can pass the Totals from the subform to the parent form, but for some reason I can't update those totals in the underlying Purchase Order table, as when a calculated control is updated it doesn't seem to trigger any...

You need to re-link your tables using the Link Table Wizard, and check the check box entitled 'Save this Password' in the dialog which asks for your username and password (you need to do this with all your password-protected linked tables). From then on, whenever you access the linked table(s)...

I don't know for sure, but you could try this: varX = DLookup("[Foreman]", "LabourNormalRate", "[CompanyName] = '" & ContractorName(X) & "'")

Does anyone know how to set which report the print dialog will print in VBA? Here's my code so far: dlgCommon.Flags = cdlPDAllPages dlgCommon.ShowPrinter Reports("PurchaseOrderReport").SelPrint _ dlgCommon.hDC See what I'm trying to do? Please help, I've been trying to work this for months...

Does anyone know how to set which report the print dialog will print in VBA? Here's my code so far: dlgCommon.Flags = cdlPDAllPages dlgCommon.ShowPrinter Reports("PurchaseOrderReport").SelPrint _ dlgCommon.hDC See what I'm trying to do? Please help, I've been trying to work this for months...