Applications.CreateControl

[msr71]

When ever I include the last two parameters width and height for a textbox the textbox does not show:



Set ctlText = CreateControl(frm.Name, acTextBox, acDetail, "", "", dblTxtLeft, dblTxtTop, dblTxtWidth, dblTxtHeight)

Any assistance, advice or solution will be greatly appreciated.

[ajetrumpet]

why are you creating controls in code? you shouldn't be doing that. I've never seen a situation where that was needed.

[msr71]

What I am trying to do is create a Data Entry Form that looks like this:

Math Bio Chem
Mark 98 95 96
Mary 75 69 54
John 52 75 86

The values of columns and rows come from database tables and the user enters grades in the textboxes that make up the table cells. I will handle the Inserts and updates with ADO.

I have another approach but I find it not to be as elegant as using the CreateControl method.

[msr71]

I have since discovered that the TextBox is being created but with a Width of 0 and a Height of 0.0007

[ajetrumpet]

I have since discovered that the TextBox is being created but with a Width of 0 and a Height of 0.0007

then you're probably getting your argument measurements confused between inches and TWIPS.

read about twips in the help menu, vba. very extreme methods like 'createcontrol' use twips. as a matter of fact, I believe all methods via vba in access that require a unit of measurement in height and width use twips.

[msr71]

Thanks AJ that was not a detail that I considered. I tried it and it worked. I've also learnt all the controls whose height and width are in TWIPS.

I will never forget this.