HELP ME!!!!!!!

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hi,

Heres the story....

Some time ago set up a client database which contains a
field "current status". This field has a drop down menu
containing several options such as "on service", "On
waiting List" etcetc.

Now somebody has decided that we need a new
entry "referred to ICT" in this drop down menu, which I
thought is simple enough. However, everytime I try to add
this to the drop down menu in the design view it tells me
that my changes cannot be saved bacause something is too
large. I tried something simple like changing one letter
of a word,(in the drop down menu) and the same error
message appeared.

What am I doing wrong??
PLEASE HELP, I have to have this done by today
 
What does it tells you exactly?
What is too large?

anyway, make sure that your drop down menu has the property "Row Source
Type" is set to Value List
and all your items (lines of the dropdown menu list) are separated by
semicolons such as
"on service"; "On waiting List";"my new line"

If this still doesn't work, create a new combo box (using the wizard) and
simply reenter all your lines from the beginning
 
Hi Lisa!

This is a little to less information to be specific with the help. It would
be nice with the exact error description from Access!

Well your combobox (dropdown menue is called combobox) could get it´s value
either from a valuelist, like Warrio mentioned but it could also be bound to
a feild in a table. Either way you could find out which of these by open up
the form in design view selecting the combobox ant open up the propertie for
this combobox (combo).

Select tab "Data" there you have Rowsource. If it´s a tablename or a
queryname or a "SELECT.....whatever" then it´s a bound control and the value
you see is stored in a table. If it´s a tablename or a queryname add the
name into your memory and go to tabel window or query window look for the
same name. Open up the table or the query (the query in design mode but the
table NOT).

If it´s a table just add (at bottom) the new value you want. Make sure it´s
not to long. It´s possible to set filedsize in designview for a field in a
table. This might be set to 20/30/50 signs or what ever. This means that
your text (I asume it´s text) may NOT exceed this number of letters and
signs. If so it will just save the 30 first signs and skip the rest. This
fieldsize may be changed (incresed) in table design view. You could also
decrese it but then you may lose some data which is allready stored in the
table.

If it´s a query:
Open up the query in design view find out which tablename stores the text
you looking for. Open up the table like I tryed to explain above!

I hope this can help you out!

// Niklas
 
Hi,

Heres the story....

Some time ago set up a client database which contains a
field "current status". This field has a drop down menu
containing several options such as "on service", "On
waiting List" etcetc.

Now somebody has decided that we need a new
entry "referred to ICT" in this drop down menu, which I
thought is simple enough. However, everytime I try to add
this to the drop down menu in the design view it tells me
that my changes cannot be saved bacause something is too
large. I tried something simple like changing one letter
of a word,(in the drop down menu) and the same error
message appeared.
Click to expand...

What is the Row Source property of the combo box? I'm *guessing* that
it's a Table, and that the actual bound field is a Number. Where are
you trying to enter "Referred to ICT"? What is the ACTUAL error
message you are getting, and when?
 
Back
Top