Recent content by lame_designer

Pono thanks, your example shows it is possible to show more than 255 characters in a textbox.. but in my case the textbox is bound to a different table so I cannot copy the code 1 on 1.. I feel so stupid, after 2 weeks I still haven't figured it out :( Regards

Thanks Rich, I'll try to figure out if i can implement your suggestions although I'm not sure if I understand what you mean by PK but i do understand your point about double data.. The big problem I have is that I don't really have the liberty to make drastic changes as the form and tables have...

Not really, what I'm trying to do is display a default letter which is supplemented with reasons why something is rejected, so it's not like I'm storing duplicates.. It is for a incident reporting database and only 1 item in the combo should display a default text.. problem is we use it for all...

No, what I am trying to say is that the data is retrieved from 1 table and stored in another.. Thanks alot pono, you might have saved me from a major headache. will check it out and let you know if I got it working :)

The Causedby and Description fields are in the same table.. I changed both fields to memo (causedby field was set to text, Description was already set to memo) but the problem is still there.. The table I store the textbox data in is also set to memo

In my form I have a combo and it is bound to a table. When select an item in the combo I a standard letter should show up in a textbox. The letter has over 500 characters. The problem that I encounter is that the textbox seems to be limited to 255 characters so only half of the letter shows up...

HEEELLLLPPPP (please) I'm stuck and I'm desperate to find some help... To get rid of the error i changed the code to : Me.txtDescription = Me.cmbCausedBy.Column(1) This works nice without any errors however "the letter to customer" stops half way.. I suspect that you can only copy 255...

Something is not right.. I get runtime error 3061 Not enough parameters.. Expected number is 1 It has a problem with this line :( Set rs = CurrentDb.OpenRecordset(Ssql)

Very helpful post, thank you.. I will use this alot.. Although in my case this option doesn't work.. I have an option group with 2 options: Dutch and English. When I select Dutch I should see a dutch letter to the customer in my text box, when I select English it should display the english...

Thanks alot MS Lady, this works like a dream when an excisting record is changed, however when i create a clean form i get a debug error in the Ssql line.. The spaces used in the table names might cause this or the conversion from office 97. I'll create a form from scratch and figure it out...

bit of a problem with that solution.. the textbox is bound to a table already..

Good idea.. gonna try that.. Thanks.. will let you know if it had the desired effect.. If I leave the extra column blanc and only fill out the "expeditor-record" it should work.. But since I'm just learning VB (inexperienced rookie I am) I would really appreciate it if somebody could tell me...

I think that would show the combo-box-item in the textbox. This is not what I'm trying to achieve. When people select "expeditor" in the combo-box it should show the following text in the textbox: "Shipment has been rejected bla bla bla" I also made a mistake in the names.. The correct names...

I have a combo and a textbox in my form. The name of the combo = cmbCaused by, the name of my textbox = txtDescription. One of the items in my combo box = Expeditors. When I select "expeditors" in my dropdown box I would like a text to appear in my textbox without having to linkt the textbox to...