In a continous form, I need txbControl1 to be conditioned according to txbControl2.
txbControl1 control source is:
=DSum("Amount","Loans","Id=Forms!Cities!Customers. Form!Id")
txbControl2 control source is [Field2] of the subform's record source table
So the condtional formatting of txbControl2 would be:
txbControl1.value = 1000
While this conditional formatting works if used on txbControl1, it causes a system hang if used on txbControl2.
Do any of experts or users know what is the reason for this, and is there a way around it?
Thanks.
4 1679
In a continous form, I need txbControl1 to be conditioned according to txbControl2.
txbControl1 control source is:
=DSum("Amount","Loans","Id=Forms!Cities!Customers. Form!Id")
txbControl2 control source is [Field2] of the subform's record source table
So the condtional formatting of txbControl2 would be:
txbControl1.value = 1000
While this conditional formatting works if used on txbControl1, it causes a system hang if used on txbControl2.
Do any of experts or users know what is the reason for this, and is there a way around it?
Thanks.
Sorry Michael, you lost me.
What are you trying to do here?
So the condtional formatting of txbControl2 would be:
txbControl1.value = 1000
You are actually telling it to put 1000 as a value into the control txbControl1 which contradicts it's control source value.
Sorry Michael, you lost me.
What are you trying to do here?
I'm using an equivalence veryfication of the other control's value with a number value as a conditional formatting for the current control.
To be percise, I need the conditional formatting on txbControl1 control to be activated whenever the txbControl2 control's value equals 1000.
so, the conditional formatting of txbControl2 that I use is
Condition 1: Expression Is: txbControl1.value = 1000
While it works when txbControl1 is a table field control, it hangs the system when it's a calculated control.
err, I'm sorry, I've made a logic mistake.
here's the corrected version:
To be percise, I need the conditional formatting on txbControl1 control to be activated whenever the txbControl2 control's value equals 1000.
so, the conditional formatting of txbControl1 that I use is
Condition 1: Expression Is: txbControl2.value = 1000
While it works when txbControl2 is a table field control, it hangs the system when it's a calculated control.
I'm using an equivalence veryfication of the other control's value with a number value as a conditional formatting for the current control.
To be percise, I need the conditional formatting on txbControl1 control to be activated whenever the txbControl2 control's value equals 1000.
so, the conditional formatting of txbControl2 that I use is
Condition 1: Expression Is: txbControl1.value = 1000
While it works when txbControl1 is a table field control, it hangs the system when it's a calculated control.
Replace the 'Conditional formatting' with code.
Example:
In the Forms On Current event put something like ... -
Private Sub Form_OnCurrent()
-
-
If Me.txbControl2 = 1000 Then
-
Me.txbControl1.Visible = True ' Not sure what conditon you want
-
Else
-
Me.txbControl1.Visible = False
-
End If
-
-
End Sub
-
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andrew |
last post by:
Last night I was reading about implementing my own stack. The example
given pushes items on and off the stack at the start and end of each
procedure (ie. in a std module). What's not so clear is...
|
by: Stuart Masters |
last post by:
Hope someone out there can help.
I have created a database which holds clients information of
assessments they have had. I have also created a simple query which
will let me know that that...
|
by: Mike |
last post by:
Using Windows XP SP-1 with all security udpates installed
MS Access version 10.2627.3501 SP-1 (all service packs to be installed over
the weekend)
MDAC 2.8
Jet 4.0 SP 8
When the database and...
|
by: John Baker |
last post by:
Hi:
I have a field that i wish to use the conditional format capability on, and for some
reason it wont work.
The field is a a text box:
=-
I would like to make it red when negative, and...
|
by: kaosyeti |
last post by:
how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up. i've been trying to find a way to format...
|
by: tg989 |
last post by:
Okay, here goes.
Continuous forms... possibly the best feature of access. The only downside is this: the only way to have a conditional evaluation run on each record invididually is by...
|
by: midlothian |
last post by:
Hello,
I have conditional formatting set up on a subform based on a calculated
value in the underlying query. For instance, if Sales are >$1000, the
query displays "Yes," otherwise it displays...
|
by: keri |
last post by:
I would like to set up conditional formatting on a form.
One of the fields on the form is a date (). If the calldate
field is over 365 days ago I would like all the other fields on the
form line...
|
by: Greg (codepug |
last post by:
Access 2000
Using a textbox of a single form, I created a calculated field. The
following code is in the Control Source for this field:
=IIf(=24,+(/),/
)
The numbers that are calculated are...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| | |