List Box Problem, - Very Strange.

[BlackFireNova]

I am working on an Access 2002 Database.

I created a new table and imported some notes data into it from an
existing table. Now, when I try to create a List Box, and it displays
the list of fields to select from, I can see every field in the new
table EXCEPT the VNotes field, (which is the one I imported the existing
Notes data into). Can anyone help me understand why the existing text
notes could be causing Access to make the field invisible to the List
Box Wizard?

Genesis of what I did:

I have a table in the database which has been in use for some time, and
has various notes made in a memo field called Notes.

I want to split the notes data out into a separate table, so as to allow
multiple notes per each record in the main table. Currently they just
string all the notes together in the one Notes field.

I created a new table called VNotes, with five fields
ID (AutoNumber)
NoteDate (date field)
Critical (Y/N Check Box)
VNotes (Memo Field)
VNmbr (Text field, set for indexed duplicates OK)

The VNmbr field is for a foreign key to sync to the VNumber field in the
primary table)

I Copied and pasted all of the existing VNumber's from the primary table
into the VNotes.VNumber field.

I then linked the two tables via the VNumber and VNmbr fields, and used
and update query and imported all of the existing notes.

I wanted to create a list box that would show the notes in the new notes
table, on a form.

When I use the wizard to create the List Box, it shows me a listing of
the fields available in the VNotes table, but the field list does NOT
contain the VNotes Memo field. It shows all the other fields, but not
that one.

The only thing I can figure is that, over the course of time, someone
has entered some text into one of those notes which Access does not
like, or is treating as some kind of command, or what, I don't know.

Anyone out there who does?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[MacDermott]

I haven't tried this out, but I think your problem may be related to this
being a memo field.
Since memo data can be as long as you want (up to 2K bytes, I think), it's
not really a good candidate for display in a listbox.

HTH
- Turtle

"BlackFireN ova" <BF************ *****@myrealbox .com> wrote in message
news:3f******** *************@n ews.frii.net...

I am working on an Access 2002 Database.

I created a new table and imported some notes data into it from an
existing table. Now, when I try to create a List Box, and it displays
the list of fields to select from, I can see every field in the new
table EXCEPT the VNotes field, (which is the one I imported the existing
Notes data into). Can anyone help me understand why the existing text
notes could be causing Access to make the field invisible to the List
Box Wizard?

Genesis of what I did:

I have a table in the database which has been in use for some time, and
has various notes made in a memo field called Notes.

I want to split the notes data out into a separate table, so as to allow
multiple notes per each record in the main table. Currently they just
string all the notes together in the one Notes field.

I created a new table called VNotes, with five fields
ID (AutoNumber)
NoteDate (date field)
Critical (Y/N Check Box)
VNotes (Memo Field)
VNmbr (Text field, set for indexed duplicates OK)

The VNmbr field is for a foreign key to sync to the VNumber field in the
primary table)

I Copied and pasted all of the existing VNumber's from the primary table
into the VNotes.VNumber field.

I then linked the two tables via the VNumber and VNmbr fields, and used
and update query and imported all of the existing notes.

I wanted to create a list box that would show the notes in the new notes
table, on a form.

When I use the wizard to create the List Box, it shows me a listing of
the fields available in the VNotes table, but the field list does NOT
contain the VNotes Memo field. It shows all the other fields, but not
that one.

The only thing I can figure is that, over the course of time, someone
has entered some text into one of those notes which Access does not
like, or is treating as some kind of command, or what, I don't know.

Anyone out there who does?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jude]

I suspect that you can't put a memo field into a listbox. I tried it
myself and you're right, the memo field doesn't show up in the wizard.
You will probably have to change your field to text, or use a
different control to view the notes.

Jude

BlackFireNova <BF************ *****@myrealbox .com> wrote in message news:<3f******* **************@ news.frii.net>. ..

I am working on an Access 2002 Database.

I created a new table and imported some notes data into it from an
existing table. Now, when I try to create a List Box, and it displays
the list of fields to select from, I can see every field in the new
table EXCEPT the VNotes field, (which is the one I imported the existing
Notes data into). Can anyone help me understand why the existing text
notes could be causing Access to make the field invisible to the List
Box Wizard?

Genesis of what I did:

I have a table in the database which has been in use for some time, and
has various notes made in a memo field called Notes.

I want to split the notes data out into a separate table, so as to allow
multiple notes per each record in the main table. Currently they just
string all the notes together in the one Notes field.

I created a new table called VNotes, with five fields
ID (AutoNumber)
NoteDate (date field)
Critical (Y/N Check Box)
VNotes (Memo Field)
VNmbr (Text field, set for indexed duplicates OK)

The VNmbr field is for a foreign key to sync to the VNumber field in the
primary table)

I Copied and pasted all of the existing VNumber's from the primary table
into the VNotes.VNumber field.

I then linked the two tables via the VNumber and VNmbr fields, and used
and update query and imported all of the existing notes.

I wanted to create a list box that would show the notes in the new notes
table, on a form.

When I use the wizard to create the List Box, it shows me a listing of
the fields available in the VNotes table, but the field list does NOT
contain the VNotes Memo field. It shows all the other fields, but not
that one.

The only thing I can figure is that, over the course of time, someone
has entered some text into one of those notes which Access does not
like, or is treating as some kind of command, or what, I don't know.

Anyone out there who does?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[BlackFireNova]

Thanks for the info.

I did find a sort of a workaround. I created my table, and then did the
list box wizard BEFORE I imported the note data. It created the list
box OK, and showed me the VNotes memo field in the wizard window. After
I did the List box I saved it in a form, and then I imported the data
and it works fine.

Of course, it doesn't show all the text of the memo field, but I wasn't
looking for that anyway. I wanted a list of the notes, and I'll set it
up so if they want to read the entire note they can double click on
whichever one they want and it will open another form which will allow
them to view it.

Thanks all.

BFN

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!