listbox headline

[carbo20]

when i choose the listbox head line, it display the variables name.
is there a way to define myeslf the headline without changing the variables?
Thank you.
Nir

 

[Mile-O]

Do you mean the field names as opposed to variables?

 

[carbo20]

i mean:

what i mean is that the first line in the list is the variables.
for example the first column head is lname and what i want to display is Last Name.
is there away of doing it?

Thank you
Nir

 

[Mile-O]

what i mean is that the first line in the list is the variables.
for example the first column head is lname and what i want to display is Last Name.

These are not variables; they are field names - there is a huge difference.

is there away of doing it?

Yes, you have to change the name of the field in the SQL or Query that acts as the RowSource for the listbox.

Thus, if your SQL looks like this:

SELECT LName FROM MyTable;

Then you would change the field name like so:

SELECT LName AS [Last Name] FROM MyTable;



In the query view, this is done by changing the field name

i.e.

LName

is changed to:

LastName: LName

 

[carbo20]

sorry you are right,

i meant fields.
i hope it will work,there is alot to change.
thank you.