fields display

[Tinky]

Hi all
How can i control the display of fields in a form?
i see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.
i can't find how it was done, i see no difference in the fields' properties.
another question is how can i make a comboBox to display just the text without the ID number

thank you
tinky

 

[pr2-eugin]

i see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.

See if the Visible property is set to Yes.. If not then you have your answer.. Change it to 'Yes' and you should see that..

another question is how can i make a comboBox to display just the text without the ID number

It depends on how you want it to be done, you can eliminate the ID column, by changing the RecordSource.. But if you want the ID to be there, but just hidden then change the Column Width property to 0cm;3.01cm then it should be fine..

 

[Tinky]

Hi
thanks but, it's not about the visible property because all the fields have this property as a 'yes' but still some of them are invisible
any other suggestions?

and as for the combo box...again-doesn't work
need another idea.
thanks for the help
tinky

 

[CazB]

Have you looked at the 'DisplayWhen' property?

... or: is there any code on the form which runs when the form opens/loads/oncurrent, which sets the fields visible property to false?

 

[CazB]

As for the combobox:

If there are two columns in it, the first being the ID and the second the 'text', then you will need to set the properties as follows:
ColumnCount: 2
ColumnWidths: 0 cm;3 cm
BoundColumn: 1

 

[Tinky]

thanks i'll try that

 

[Tinky]

Ok
so it works, but
somehow i cant make the combobox actually to get the value of the text in the list. instead it keeps saving the id.
also in the control source propety it keeps showing the text 'Expr1000' instead of what i insert there.

what to do?
tinky

 

[CazB]

Oh, right... if you want to store what's in the second column, just change the boundcolumn to 2

AS for the Expr1000 - sorry, not sure what you mean?

 

[Tinky]

ok that helps for the display of the combo box
but
when i play it and choose one of the textual options in the box, it says that the field can't contain this kind of data.
i suppose it's connected to data type declaration.
cant find how...
oooooofffff :banghead::banghead::banghead:

about the weird 'Expr1000' -it's exactly how i described it
can't give any better description

thank you
tinky

 

[CazB]

Post a sample?

 

[Tinky]

sorry, i have a problem with the upload here.
i'm trying something else - like setting Pk and Fk at the source tables in SQL server and then try again.

 

[Tinky]

So yes it works well now
but still the weird Expr1000 still appears and now there is a sample image

 

[CazB]

the ControlSource of your combo79 is Expr1000.... my guess is (though it's hard to tell here) that in the recordsource of the subform, you've either included the same field twice, or you're using data from 2 tables in your record source, both of which contain the same field.... and it's called the second occurrence Expr1000 because you can't have two fields with the same name.
Have a look at the recordsource of your subform....

Oh, and I think you have to make about 20 posts before you can post a database file - but you can zip it and post that, if that might help!