Recent content by vicktown2

How can i password protect certain forms in a database without placing a password for the entire database?

Ok it seems like everythign is working well now. Thanks for your help pal.

Where exactly are you putting this line. As the control source? or somewhere else on teh report or query?

Thats what i just said doesnt work. By using the IIF command access automatically returns a test value that can only fit 255 characters. WHat i need is a similar command or routine that will return a memo value of up to 64,000 characters. Thanks for the effort. So far things that dont work...

This would work if i wanted to know if it existed , but i actually want to print the memo to a record. If I call the memo in this statement Access will show it as a text value and thus truncate the memo.

Using a report I would like a text box to show information from a memo field if the field is not empty, and to show a brief message if it is empty. I have run into truncation problems when using an expression using the IIF commands and the Nz command because these commands only work with Text...

Hello, i am using a drop down list of numbers that will be used to populate a form when a number is selected. I have been able to do this successfully when basing my find on a text type using the code below. How can i alter this code to make it work for a number? I know i should be removing the...