473,836 Members | 1,435 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Margin area in textbox not set correctly with conditional formatting.

I'm having a problem with MS Access 2003 and its conditional
formatting.

I have textboxes on a continuous form whose left and right margins are
set to 0.03 inches. Based on each textbox's current value, I set its
background color. No problem with this part.

My problem is that when clicking different text boxes representing the
records on the continuous form, the left and the right margin areas do
not always take on the background color set by the conditional
formatting. They seem to refresh to some default background color. In
other words, the left and the right margin areas of each textbox are
set with some default background color, while only the middle area
gets the conditional formatting color. If I set the margins to 0",
the problem goes away.

Is this a bug in Access 2003? Any workarounds would be helpful since
I need the margins to remain at 0.03".

Thanks.
Feb 25 '08 #1
2 3328
Robert, I've not observed that particular issue, but there certainly are
bugs in the way Access 2003 handles internal margins in controls. Scrollbars
fail. Size-to-fit doesn't work correctly. It would not be surprising if CF
didn't work correctly either.

You will probably find these issues are fixed in Access 2007, but AFAIK
there's no fix for A2003. If you are desperate, you can fudge it by placing
another text box behind your real one instead of using internal margins. The
other text box would be unbound, larger, locked, not enabled, and
conditionally formatted also.

--
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.

<ro***********@ gmail.comwrote in message
news:aa******** *************** ***********@62g 2000hsn.googleg roups.com...
I'm having a problem with MS Access 2003 and its conditional
formatting.

I have textboxes on a continuous form whose left and right margins are
set to 0.03 inches. Based on each textbox's current value, I set its
background color. No problem with this part.

My problem is that when clicking different text boxes representing the
records on the continuous form, the left and the right margin areas do
not always take on the background color set by the conditional
formatting. They seem to refresh to some default background color. In
other words, the left and the right margin areas of each textbox are
set with some default background color, while only the middle area
gets the conditional formatting color. If I set the margins to 0",
the problem goes away.

Is this a bug in Access 2003? Any workarounds would be helpful since
I need the margins to remain at 0.03".

Thanks.
Feb 26 '08 #2
Allen,

Thanks for your suggestion. I will try that approach.

Robert

On Feb 26, 3:04*am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Robert, I've not observed that particular issue, but there certainly are
bugs in the way Access 2003 handles internal margins in controls. Scrollbars
fail. Size-to-fit doesn't work correctly. It would not be surprising if CF
didn't work correctly either.

You will probably find these issues are fixed in Access 2007, but AFAIK
there's no fix for A2003. If you are desperate, you can fudge it by placing
another text box behind your real one instead of using internal margins. The
other text box would be unbound, larger, locked, not enabled, and
conditionally formatted also.

--
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.

<robertng90...@ gmail.comwrote in message

news:aa******** *************** ***********@62g 2000hsn.googleg roups.com...
I'm having a problem with MS Access 2003 and its conditional
formatting.
I have textboxes on a continuous form whose left and right margins are
set to 0.03 inches. *Based on each textbox's current value, I set its
background color. *No problem with this part.
My problem is that when clicking different text boxes representing the
records on the continuous form, the left and the right margin areas do
not always take on the background color set by the conditional
formatting. They seem to refresh to some default background color. *In
other words, the left and the right margin areas of each textbox are
set with some default background color, while only the middle area
gets the conditional formatting color. * If I set the margins to 0",
the problem goes away.
Is this a bug in Access 2003? * Any workarounds would be helpful since
I need the margins to remain at 0.03".
Thanks.- Hide quoted text -

- Show quoted text -
Feb 26 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5943
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be terminated by pressing ++ and then terminate the process. I searched the entire internet and found out that there could be two things wrong (both of them are mentioned in the bug list on the access
3
8831
by: Roberto Castro | last post by:
Hello! I have been assigned for the first time an adp Access project and so far I have managed to make the changes needed for some requirements. However, I am struggling to find the place where the application changes the color of the background of a textbox. Here the explanation goes: This is a form bound to an SQL view. The detail section has several fields, one of them being a textbox of name "Type". I checked its
4
3149
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the background colour. In A2000 it works great, but in A2003 the background doesn't always change and when it does it only changes when the record looses the focus. Any way around this? Is it a bug? Or have they "improved" it?
0
657
by: GGerard | last post by:
Hello With MSAccess 2000, I have created a program with forms and applied some Conditional Formatting on some of the text box.
8
8522
by: Typehigh | last post by:
I have many text fields with conditional formatting applied, specifically when the condition is "Field Has Focus". Without any events associated with the fields the conditional formatting works perfectly. However, I have code that runs under the ON CLICK event. The code changes the focus to other controls, which means the conditional formatting is no longer displayed. This part makes sense to me. Here's what doesn't make sense. The last...
2
11219
by: Steve Richter | last post by:
I want my panel to have an inner margin. Problem is label text does not appear to recognize the margin. In this example, the TextBox aligns on the margin, the label does not: <asp:Panel id="Panel1" runat="server" BackColor="gainsboro" Scrollbars=Both Style="margin:25px;" Height="200px" Width="300px">
4
8983
by: slinky | last post by:
Thanks in advance... I have a continuous style form with a field for each record called "STATUS". I simply want to have the form load and if the value of the textbox is "Inactive" I want the textbox background to display yellow, else I want it to be just white. Here's my code... but it is not working Private Sub Form_Load() If Me!STATUS = "Inactive" Then Me!STATUS.BackColor = RGB(255, 255, 0) Else
7
3447
by: GTalbot | last post by:
Hello fellow authoring.stylesheets colleagues, Can someone please explain why the bottom margin of the last inflow block-level child in an overflowed parent should not have its margin reachable. I read and re-read carefully the CSS 2.1 spec and I just can not see why. Related webpages: http://www.gtalbot.org/BrowserBugsSection/MSIE8Bugs/MarginBottomChildNotRendered.html
3
5021
by: jthomps8 | last post by:
Hello All. I have been struggling with how to get a field to print only on the first page of an Oracle Report in the margin section. We are running Oracle Reports R6i. All pages except page 1 should have spaces in that area of the margin. I have been playing with triggers, conditional formatting, the 'print object on' parameter and formula and placeholder columns. Is there a way that I can reference the page number to conditionally print...
0
9671
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10852
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10556
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10257
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7793
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6980
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5829
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3116
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.