Recent content by Ben Scanlan

Has anyone heard about those new corduroy pillows? They're making headlines!:cool:

Have you heard about those new corduroy pillows? They're making headlines.... :cool: PS. Sorry....

Ken, Is this a new function in Access? I'm using Access 2000 and get the message "undefined function 'InStrRev' in expression". Thanks Ben

Hi Everyone, I have a table's memo fields containing text such as: Are loan details correct? Failed. They are not correct Are signatures verified? Has partner co-signed? Failed. No verification or co-signature This would be fairly simple if could be sure they was only 1 question mark in each...

Thanks for the help. Got the syntax correct by put some of the expression in square brackets (because I has spaces in control names) . I've managed to solve the problem by using a similar expression in a macro. Cheers

Hi, I am having trouble using the Query builder to enter a validation rule for a control on a form. :confused: The Form is called [CAPs Initial] and the control is called [Report Ref]. I want the validation rule to lookup values in a separate table ( table name: [CAPs Report Reference]...