=[FieldA].[COLUMN](3) does not show

[AlexBen]

Good day! I have 5 text boxes in the form. The [FieldA] has a row source:
SELECT TAGpg.[SownID], sowTAGpg.FDate, sowTAGpg.LiveB, sowTAGpg.Stillb, sowTAGpg.Mumes FROM sowTAGpg ORDER BY sowTAGpg.[SownID]

the succeeding text boxes has =([SownID].[COLUMN](1)) to COLUMN(4)
only COLUMN (1) and COLUMN(2) is showing the value. COLUMN (3) and COLUMN(4) are blank although they have data on it.



how can I make it show that? Thanks in advance!

[Minty]

Check the number of columns property of the combo box.
Just adding the fields to the combo's query doesn't make them available if there aren't enough columns in the combo.

[Micron]

I'm thinking there is no query or textbox involved. The row source for the main tb is a sql statement but can you even use a sql statement for a textbox, especially one that returns several fields? Maybe yes if it's a multi value field (which is something I don't use). Also, don't overlook the fact that columns are usually zero based, so 1,2,3,4 is probably wrong in the first place.

[mike60smart]

I agree with Minty the Column Count of the Combobox should be 5
Check the properties of the Combobox

[AlexBen]

Hi Micron! Sorry, i used a combo box for FieldA

[AlexBen]

Hi Minty! I don't do ACCESS much so some terms I don't know... where can i check the column property of the combo box? should it be in the table or form? i did change the BOUND COLUMN but it did something else (did not show my list). Thanks in advance!

[mike60smart]

Hi Alex

It is in the design View of the Form
Click on the Combo Box and then Right click and select Properties

Then check the Column properties as shown

[Micron]

You might want to bookmark the root of this site
https://learn.microsoft.com/en-us/of...ombobox.column

Properties of objects are listed on tabs of the property sheet when the object is in design view.

[AlexBen]

Thank you! I was looking for it at the DATA folder of the Property Sheet.

[Micron]

Those "folders" are known as tabs.