Removing Dropdown Arrow From Locked Field

SteveM

I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Any ideas.

Thanks,

SteveM

Jul 27 '06 #1

Subscribe Reply

4200

Allen Browne

There are fudges that place a graphic over part of the combo, or a text box
on top of it bound to:
=[Combo1].Column(1)
or whatever.

But a simpler solution might be to create a query that contains both your
main table and also the lookup table, and use the query as the Record Source
of the form. You can then include the value from the lookup table, so you
can use a text box instead of the combo.

(One potential hazard here is if any of the lookup table's fields have a
Default Value assigned, you may need to clear that so you don't run into
problems adding new records to the form.)

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

"SteveM" <sb****@vzavenu e.netwrote in message
news:11******** **************@ 75g2000cwc.goog legroups.com...

>I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Jul 27 '06 #2

SteveM

Allen,

Thanks Much,

SteveM

P.S. Perth Austrailia - the internet is a wonderful thing.

Allen Browne wrote:

There are fudges that place a graphic over part of the combo, or a text box
on top of it bound to:
=[Combo1].Column(1)
or whatever.

But a simpler solution might be to create a query that contains both your
main table and also the lookup table, and use the query as the Record Source
of the form. You can then include the value from the lookup table, so you
can use a text box instead of the combo.

(One potential hazard here is if any of the lookup table's fields have a
Default Value assigned, you may need to clear that so you don't run into
problems adding new records to the form.)

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

"SteveM" <sb****@vzavenu e.netwrote in message
news:11******** **************@ 75g2000cwc.goog legroups.com...
I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Jul 27 '06 #3

ManningFan

Can't you just change the field to a text box? Format ->Change To ->
Text Box

"SteveM" <sb****@vzavenu e.netwrote in message
news:11******** **************@ 75g2000cwc.goog legroups.com...

>I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Jul 27 '06 #4

Similar topics

10752

Javascript dropdown - dynamic width text, static length control

by: Robert Mark Bram | last post by:

Hi All! Has anyone seen an example of the following javascript powered control: - a dropdown select menu - the width of the control is set. Assume by "control" I mean the visible part of the drop down before a mouse click occurs. - the width of the list when selected is dynamic - the width of the list can grow beyond the width of the control without changing the width of the control.

Javascript

2719

Textfield with a dropdown list while writing some text

by: t.kiesche | last post by:

Hello I want to make a textfield (INPUT type=text) or something that looklike this, to drop down a list with word. Just like: A user writes the letter 'a' and in the dropdown list come a list of word starting with 'a'.

Javascript

10287

combobox dropdown

by: Gil | last post by:

Is there a way to tell if a combbox is in dropdown mode. I tried and if statement combobox.dropdown = true but i get an error. dropwndown function doesnt store if its true or false what i am trying to do is make an autoscroll combobox. like you have on html textbox's, but this time you hit enter for a change to be made. i do this because i dont want to requery every time a single letter is inputed. it would be too slow. so i make them hit...

Microsoft Access / VBA

1428

Preserving 'Arrow' Appearance Of Pointer Over Text Control?

by: (PeteCresswell) | last post by:

Got a text control that where .Locked = True. I have the text blue and underlined to simulate a clickable link on a web page. If the user clicks on that field, I open up a window that shows the detail behind that text. Only problem is that then the user moves the mouse pointer over the field, the mouse pointer turns into an insertion point.

Microsoft Access / VBA

5880

Type ahead dropdown box

by: Peter | last post by:

Does anyone know of a good dropdown WebForm control that works like the Windows Forms dropdown control with type ahead feature, Where user can type in a value and it automatically displays the like values in the listbox, or user can click on the down arrow to bring a list of all items? I have found controls but they either do no let you type in the box or there is no down-arrow to click to display all of the items in the listbox, just...

ASP.NET

4723

dropdown Listbox open

by: fat | last post by:

I have a drop down combo box that displays a list of customers , and the list is growing.. I would like to click the dropdown arrow and have a List box in a new form open, then i can choose a customer and pass it back to the combo box. can anyone help me thanks in advance d

Microsoft Access / VBA

2209

Removing Customize Dropdown on a Custom Toolbar

by: Sky | last post by:

I have an Access 2003 front-end database with custom toolbars. The toolbars work fine. One annoying feature is that at the far right edge of each custom toolbar there a small dropdown arrow. When you hover over it with the mouse, a ControlTip Text of "Toolbar Options" is displayed. If you then click on the dropdrown arrow, it displays a popup menu of "Add or Remove Buttons", with a fly-out menu with the toolbar name at the top and...

Microsoft Access / VBA

1192

Some help with dropdown menus

by: angelinahmaleka | last post by:

Hi, I have just joined the forum and I need help with Javascrip dropdown menus. I have written a function which should change the background image of a button when it is clicked: function change(el) { if (el.style.background='url(arrow-up-title2.jpg)'){ el.style.background='url(arrow-down-title2.jpg)' } if (el.style.background='url(arrow-down-title2.jpg)'){

Javascript

1420

How to widen dropdown list column in GridView?

by: progman417 | last post by:

I have a gridview with a dropdown list in an EditItemTemplate. I haven't set a width for the columns, so that they dynamically size according to the data displayed. When it goes into edit mode I want to make the dropdown lists a bit wider to allow for the width of the arrow, and widen the column accordingly. If I set the width of the dropdown list to a fixed unit such as 300px; then it widens the column accordingly. But if I...

.NET Framework

8390

Changing the language in Windows 10

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

Windows Server

8911

Problem With Comparison Operator <=> in G++

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

C / C++

8819

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

8667

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

7428

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6222

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

4402

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2808

transfer the data from one system to another through ip address

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

C# / C Sharp

2048

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP