Recent content by tictac1101

Thanks for your replies... I ended up creating 100 small invisible text boxes on my form and going with the set visible = true method. Using the controls index number I am able to set the x,y coordinate, width, etc depending on the value in a combo box. A little messy but it works perfectly...

I imagine the fields you have on the form that show calculated values (VAT, Discount, etc) are unbound. Meaning they are not linked to a field in the table. If you go into the control properties you will see the control source is an expression for the calculated fields and a field name from the...

Thanks for your reply gol4. I am aware of this function, but as you said it needs to run in design view. Unless there is a way to switch from design view to form view using vb, then this would only be usefull for creating wizards etc? I think I might have to create a heap of invisible text...

Is it possible to create multiple text box controls on runtime in Access 97/2003? The reason for this, is because the controls dimensions/values need to be set using data from a recordset. Because I don't know how many controls will end up being on the form, I can't simply use the hide/unhide...