473,837 Members | 1,701 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Service Pack 3 & Combo box problem

Hi,

I decided to install Office 2003 Service Pack 3 on my home computer to test
(in full knowledge that there may be some issues with it). After installation,
I have noticed that with a small database I wrote for home, the combo boxes
and listboxes no longer display the bound column. For example, on a form I
have a combo box based on a table called 'names'. The two columns in the
combo box are ID and Surname. The combo box and list box show two columns but
the first (bound) column is blank. If I open the form in my database above
and create a new combo box, the bound column is not displayed but if I create
a new database and create a new form and combo box based on a table with
dummy data, the combo box displays correctly.

Prior to installing Service Pack 3, they were displaying correctly.

I would appreciate any suggestions/advice.

Thanks
Anthony

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 19 '07 #1
2 7056
Sky

I just posted a similar question in microsoft.publi c.access.module sdaovba.
If you have custom formatting on the fields in the underlying tables for the
RowSource, you might try removing the custom formatting.

Here was my post:

I just installed the new Service Pack 3 for Office 2003.

This has caused a strange display problem in Access 2003 with combo boxes on
tables that have a formatted text field.

To see this problem, create a table named TableX with a single key field
FieldX that is a text field. (Use any table name or field name you like.)
Add a few rows of data, such as a, b, c.

Create a simple test form with a combo box that has SQL such as "Select
FieldX From TableX". Save the form. The combo box dropdown displays just
fine and you can select values.

Now go to design view on TableX and change the format property of FieldX
to have any format, such as &[Blue]. (This particular format displays the
FieldX in a blue color, which I use to indicate key fields during
development,
and it propagates to queries. But any format seems to cause the problem.
The users, of course, always view data in forms.)

Suddenly the combo box on the test form is completely blank. The combo box
does have data (for example, from the Immediate Window,
?Screen.ActiveC ontrol.ListCoun t has the correct value of 3),
but the display is all blank and you cannot actually see any of the dropdown
rows.

It does not matter what format is applied to FieldX, or whether the form
combo box has formatting or not, the combo dropdown is blank.

The formatting on FieldX should have nothing to do with the combo box
display.

But for some reason, the field format interferes with the combo box display.

Prior to Service Pack 3, this was never an issue. (Nor was it ever an issue
in prior versions of Access.) Am I missing something? Any suggestions for a
work-around?
"biganthony via AccessMonster.c om" <u31673@uwewrot e in message
news:78722d8c68 020@uwe...
Hi,

I decided to install Office 2003 Service Pack 3 on my home computer to
test
(in full knowledge that there may be some issues with it). After
installation,
I have noticed that with a small database I wrote for home, the combo
boxes
and listboxes no longer display the bound column. For example, on a form I
have a combo box based on a table called 'names'. The two columns in the
combo box are ID and Surname. The combo box and list box show two columns
but
the first (bound) column is blank. If I open the form in my database above
and create a new combo box, the bound column is not displayed but if I
create
a new database and create a new form and combo box based on a table with
dummy data, the combo box displays correctly.

Prior to installing Service Pack 3, they were displaying correctly.

I would appreciate any suggestions/advice.

Thanks
Anthony

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 19 '07 #2
I took the custom formatting out from the underlying tables and the combo box
and the list box works as expected. I also tried Ken Snell's solution and it
worked.

Hope there will be a fix

Anthony
biganthony wrote:
>Thanks for the replies. I will try tonight the solution offered. I am using
Windows XP x64 Edition SP2.

Regards
Anthony
>>Ken Snell suggested this work-around in
microsoft.pub lic.access.modu lesdaovba:
[quoted text clipped - 16 lines]
>>>Thanks
Anthony
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 20 '07 #3

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

Similar topics

0
1810
by: Phoenix_Dfire | last post by:
We've had a working application for the last year, which involved Microsoft ASP serving up web pages, which were generated from data retrieved from an Oracle Database via ADO. However, as part of this fix for the msblast virus, our server was upgraded to service pack 4 and as a result, our web pages started to fall over with an ASP Ď0x800a01fb' error when attempting to read the EOF flag of a recordset. At present we use Oracle's...
2
1914
by: Don Peters | last post by:
In spite of trying various ways of loading .NET Framework 1.1 Service Pack 1 under my new WinXP Service pack 1, I was unable to get it to install. Typically, the installation would hang after a minute or two of execution. After many hours of frustration, I called Microsoft tech support and discussed the issue with them. After asking around, the support person said there indeed was a bug in the installation file, and to forget about it...
0
4163
by: Tiziano | last post by:
I currently have installed .NET Framework 1.1 (_not_ the SDK version, though) on a Win2K PC. I am unable to apply the above-mentioned service pack via Windows Update. In the middle of the update process, Windows Installer informs that the update failed but gives no reason. I downloaded the service pack and tried to install it manually, but I have the same problem. I think that the cause of all this is that I deleted
2
2392
by: jerry | last post by:
I'm trying to run an application under another user within a winform app writen in C#. I have tried a number of different things, but it seems that the CreateProcessWithLogonW function should work to do what I need to do. This appears to work just fine in Windows 2000 and XP with service pack 1, but it doesn't work with XP service pack 2 installed. I'm sure it's one of the "Enhanced security features" of service pack 2, but I can't...
1
2318
by: Simon Chester | last post by:
Hello! Can anyone help me with this problem?... I have developed an ASP.NET (version 1.1) application which I have deployed to a number of webservers. The web application works fine on Windows 2000 Server computers. It also works OK on Windows 2003 Server UNTIL Windows 2003 Service Pack 1 is installed! The error and stack trace I am given is:
0
1749
by: InstallAware | last post by:
Dear Group If you want to perform a slipstreamed install of .NET Framework 1.1, including Service Pack 1, here's how. First, what do we mean by slipstreamed install? It means that version 1.1 of the framework will be installed, with the service pack 1 update already applied, "slipstreamed". There will be no need to download additional updates or install service packs as a secondary step.
18
2017
by: jayderk | last post by:
a customer was trying to install some of our software after they installed the windows XP service pack 2 and he is getting a message that says something about it not being compatable with windows XP? we have our software on thousands of XP boxes and have not had a problem up to this point. Any Clues/suggestions on what it could be? Regards, Jay
1
1939
by: AspDotNetDeveloper | last post by:
Hello, I have Windows 2003 Server with .Net Framework 1.1 installed (part of the OS), and have used Windows Update to install the Service Pack 2 (the only way you can install it). The install seems to go fine, but Windows Update keeps telling me I need to install Service Pack 2. I have had this happen on other computers. Has anyone else experienced this? I'm wondering if it is installing it or not. I am investigating this, as I am...
13
6664
by: dancer | last post by:
I have made a new post because when I try to respond to another, I get the error, "Article Rejected -- Ill-formed message id" This is in response to the advice of Juan Libre to install Net Framework Service Pack 1 in order to use ASP.net 1.1 and the net Framework 1.1 ------------------------------------------------------------------------------------------------ I found the following file, "svcpack.log" at C:\WINNT. It contains many...
0
9846
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
10897
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
10583
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...
1
10638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10280
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...
0
7009
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
5679
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...
1
4481
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3128
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.