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

Hi,

Trouble's back

Still can't get this right.

Currently I have:

txtCurrent = "F" & Fieldss

Forms!tblExcel_Check.txtCurrent.FormatConditions.Add acExpression,
acEqual, "[GroupOrderNo]=1",
Forms!tblExcel_Check.txtCurrent.FormatConditions.Item(0).BackColor =
15592886


I have a defination problem.

Can you be good enough to correct it for me.

"Allen Browne" wrote:

This example adds a format condition to the text box named Amount on Form1,
to show negative values in red:

With Forms!Form1.Amount.FormatConditions
.Add acFieldValue, acLessThan, 0
.Item(.Count - 1).ForeColor = vbRed
End With

--
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:1AF62A77-E21E-46C5-A6CE-0F6F616D14AF@xxxxxxxxxxxxxxxx
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.

"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
    ... FormatConditions collection to add up to 3 format conditions. ... Allen Browne - Microsoft MVP. ... If you are designing some kind of wizard/tool for development purposes, ... I am ok with the loop but just how do you add a textbox to a form using ...
    (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: Creating search form to return results in report
    ... Allen Browne - Microsoft MVP. ... Are they check boxes? ... >> The sample database in the article shows the search results in the>> form, ... >>> name in one textbox, ...
    (microsoft.public.access.formscoding)