Combobox display question

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

When I click my combobox, it shows me 2 columns. When I select an item, it
only shows me 1 column. In searching I found that the combobox will only
display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox right
behind it to display my next column of the combobox. Now I need the textbox
to look at column 2 of my combobox. If I put =cbProcedureNum in the control
source it shows me the bound column, is there a way to offset it by 1?

Thanks everyone for the awesome support,
Chad
 
I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " --- Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.


Gina Whipp said:
Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Chad Cameron said:
Hi All,

When I click my combobox, it shows me 2 columns. When I select an item,
it only shows me 1 column. In searching I found that the combobox will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum in
the control source it shows me the bound column, is there a way to offset
it by 1?

Thanks everyone for the awesome support,
Chad
Click to expand...
Click to expand...
 
Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

KARL DEWEY said:
I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.


Gina Whipp said:
Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Chad Cameron said:
Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need
the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad
Click to expand...
Click to expand...
Click to expand...
 
Gina

Actually, you may have done something similar already ... consider looking
for a person in a combobox ...

Having LName, FName is convenient, no?
Jeff B.



Gina Whipp said:
Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

KARL DEWEY said:
I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.


Gina Whipp said:
Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox
will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need
the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad
Click to expand...
Click to expand...
Click to expand...
 
Jeff,

i usually put that in the Tool Tip, never occured to me to just have it in
the combo box. Who is that says "...more than one way to skin a cat..."

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Jeff Boyce said:
Gina

Actually, you may have done something similar already ... consider looking
for a person in a combobox ...

Having LName, FName is convenient, no?
Jeff B.



Gina Whipp said:
Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

KARL DEWEY said:
I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER
BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.


:

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox
will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I
need the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad
Click to expand...
Click to expand...
Click to expand...
 
Back
Top