Spelling mistakes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new at this, of course!

I made a "list box" and of course I made a spelling error! I double clicked
on it, which brought up the properties and corrected the spelling, but when I
close out of the property box the spelling error is still there. So
obviously I am doing something wrong!?

How do I change this correctly?
 
? what spelling error? in which property of the listbox? how and when is
ACCESS telling you that you have a spelling error?

We can't see your database, and have no idea of the context in which you are
experiencing this issue.
 
Ken Snell said:
? what spelling error? in which property of the listbox? how and when is
ACCESS telling you that you have a spelling error?
Click to expand...

Access ISN'T telling me I have a spelling error!! I can see that I have one.
It's a list box with several names in it. One of those names is spelt
wrong, I would like to correct it.

We can't see your database, and have no idea of the context in which you are
experiencing this issue.
Click to expand...

I'm well aware that you can not see my database! All I am saying is that I
made a database... within that I have a "LIST BOX" (like a drop down menu)
and it has peoples names in it so I can select who has what task. I spelt
someone's name wrong and I would like to fix it. I go into the properties of
that box and change it. But once I close it, it's still spelt wrong.
 
No need to be snippy. Your description left a lot to one's imagination, and
I was trying to get you to focus specifically on what you are seeing and
describing.

I do not know what the RowSource of your listbox is. Is it a Table/Query, or
is it a Value List? I assume that you are referring to the spelling of a
value in a list, but need to know how the listbox is configured and what is
the source of its data.

--

Ken Snell
<MS ACCESS MVP>
 
I think we are getting off on the wrong foot! Didn't mean to sound snippy
wasn't my intention! I guess I simply don't know what that all means: value
list, table, query, etc. I thought it was simple to make a box with a list
of peoples names and when I assigned them a task I could just select their
name. But I made a mistake and spelt someone's name wrong. Where do I found
out what kind of box it is? When I created it, I selected LIST BOX.
 
OK. Now let's focus on what you're doing on the form.

I am guessing that the error is in the data that you're displaying. For a
list box, the data can come from a table in the database, or from a query
that gets data from one or more tables, or from a list that you typed into
the list box when you were creating it (I assume that you created this via
the form's control wizard?).

So, let's get a picture of what you have. Open the form in design view, and
click on the list box. Then click on the Properties icon on the toolbar. You
will see a window with various tabs.

Click on the Data tab. Post here the information that is stored in the boxes
for these properties:
Row Source Type
Row Source
 
The control source for your combo/list box is either a value list (that you
entered just for this control) or a table/query of other records (like first
and last names from your tblPeople. You will have to correct the
misspelling in either of those spots; you cannot edit the values in the
combo/list box when it drops down.

BTW, the word is "spelled", not "spelt"
-Ed
 
Sounds like you have "hard coded" your people list into the ListBox.

You will probably want to put the people into a table then use that table as
a source for the Listbox. Then, when Joe quits and or Jim is hired you just
add them to the table and they show up as options. Otherwise you will have
to go into your application file and find where you listed Joe and delete
him then add Jim.

Table People may look like
PeopleID (autoinc)
LastName (text)
FirstName (text)
ShowAsOption (yes/no)

1001 Smith Joe no
1002 Jones Jim yes

LookupQuery to base the listbox on (qryListBoxNames)

Select PeopleID, [LastName] & " " & [FirstName] as [display] from
PeopleTable where ShowAsOpton = yes

You should use the PeopleID as the 'data source' that way when you find out
Joe is really a Smithe not a Smith you make the changes in the table and now
his name is corrected throughout the database.


Cheers,

Ed Warren
 
Back
Top