Re: Using VBA need to add a text box to a form

Sorry Alan,

Just a bit thick on this point. how do a do add method if possible give an
example

Regards.

Trev.

ps I am always glad when you reply as you always give the best, most correct
and to the point answers.

"Allen Browne" wrote:

If the control is a TextBox or ComboBox, you can use the Add method of its
FormatConditions collection to add up to 3 format conditions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Trever B" <TreverB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13EC3E5A-F8B6-4BFD-BA68-AE09164A0505@xxxxxxxxxxxxxxxx
Thanks for that.

How for the follow up.

Is it possible at the time of adding the item to put a conditional format
in
place.

If so, How.

If not how do I get around it.

Thanks

Trev

"Allen Browne" wrote:

You cannot do this while the form is in use, so this technique is not
suitable for any database where you plan to release an MDE for users.

If you are designing some kind of wizard/tool for development purposes,
you
can create a text box like this (assuming Form1 is open in design view):

Dim txt As TextBox
Set txt = CreateControl("Form1", acTextBox, acDetail, , , _
1440, 1440, 1440, 285)
txt.Name = "MyNewControl"

"Trever B" <TreverB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1EFA54B-E78D-4CD4-9E32-5B5732E185CF@xxxxxxxxxxxxxxxx
Hi,

Thanks in advance.

Using VBA I want to a boxes to a form.

I am ok with the loop but just how do you add a textbox to a form using
code.



.

Relevant Pages

  • Re: Using VBA need to add a text box to a form
    ... Form tblExcel_Check must be open in design view. ... The form must have a textbox named txtCurrent, ... Another way to get the result you are after is to manually add the format ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: Using VBA need to add a text box to a form
    ... If the control is a TextBox or ComboBox, you can use the Add method of its ... FormatConditions collection to add up to 3 format conditions. ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: Using VBA need to add a text box to a form
    ... Allen Browne - Microsoft MVP. ... txtCurrent is a string and the Added fields are F1 to F unspecified ... The form must have a textbox named txtCurrent, ... Another way to get the result you are after is to manually add the format ...
    (microsoft.public.access.formscoding)
  • Re: Using VBA need to add a text box to a form
    ... Allen Browne - Microsoft MVP. ... FormatConditions collection to add up to 3 format conditions. ... If you are designing some kind of wizard/tool for development ... I am ok with the loop but just how do you add a textbox to a form ...
    (microsoft.public.access.formscoding)
  • Re: Use TextBox Text As Function Name!
    ... the text in the TextBox changes to "<the name of the ... > OptionButton that was checked just before the selection change>2<the ... You have some design issues here. ... using the most common format. ...
    (microsoft.public.vb.general.discussion)
Loading