Controls Underlying Field Size

[GrantDB]

Hi everyone,

I want to be able to find the size of a field that is linked to a textbox. For example, if the control, let's say a textbox, is named txt1 how can I find out the sizee of the field it is linked to.

I can find the field using - Me.txt1.ControlSource but then what?

Basically the user will be doing some copying and pasting and I want to do some validation before the text is pasted into the control.

Thanks in advance

Grant

 

[danvlas]

fldSize=RecordsetClone("FieldName&quot.Size

HTH

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[GHolden]

This will return the size in bytes of the field behind a control on a form.
It will only work if the form is bound to a table, because it uses TableDef for returning the Control source of the form.


Dim db As Database
Dim tbl As TableDef


Set db = CurrentDb
Set tbl = db.TableDefs(Me.RecordSource)
MsgBox tbl.Fields(Me.textboxname.ControlName).Size


db.Close
Set db = Nothing

There are two ways to write error-free programs; only the third one works.

 

[danvlas]

I really don't see why you need to declare so many variables in this instance...
Without them, it works for any recordset, even a clone one


Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[GHolden]

Yep, I realised that when I saw your post, it's not something I'd actually done before and that was the first way I thought of.

to you.

There are two ways to write error-free programs; only the third one works.

 

[GrantDB]

Thanks to everyone, it worked.

Grant