Search results for query: *

Thanks for all your help... Here's the solution: This didn't work: If rst!(ctl.Name).Type = dbMemo Then This works: If rst.Fields(MyCtrl.ControlSource).Type = dbMemo Then Thanks you all

Thanks for your help Aceman... I'm new at using VBA to let access to the things I want... so sorry for not being clear when asking questions.. I tried to use the recordset code you gave me but I'm still getting an error. The error is: "Type declaration character does not match declared data...

I know and I did follow his advice and saw that... But I didn't write this piece of code myself (see link for original code) and I saw any comments with it that it didn't work..And the creator states that it has been tested properly.. What would then be the proper way to make a difference...

Sorry if i wasn't clear enough... Hope you can still help me out... Here is the whole code I used: http://www.tek-tips.com/faqs.cfm?fid=291 My problem is in this piece of the code: If (MyCtrl.ControlType = dbMemo) Then Hist = "tblHistMemo"...

Hi, I'm also trying to make a changelog.. I have a piece of code that checks if a control on a form is a textfield or a memofield.. I'm using this code for it but the MyCtrl.ControlType results in a numeric value everytime so the statement is False everytime.. Does anyone know why this doesn't...