Change Case
String Functions

Sorry ALEX...I manufacture bedsheets and I wrap them with a trademark case
Some customers need a different name of casing
I want to display this specific trademark wraps of bedsheet in my form
Thank you for the attention

Hi Liem, Is this simply an image that you are trying to display? John

What's a trademark case or a trademark wrap?

I, like probably many, haven't worked in the manufacture of bedsheets so you'll need to explain with an example that relates to either something Rich has already done or some more detail.

Ya I am sorry.....Display here I meant to show up the casing name og a field in orderdetail form
I am very sorry

I want to show up the casing field in the orderdetailf like new price
using this me.newprice=me.productnamecombo.coloumn(2)

Hi Liem, Do you have a table such as CasingT, with CasingID, CasingName, Etc ? If so, you could use a combobox on the OrderDetailF to choose the Casing that you want. This will enter the CasingID in the OrderDetailT for you. If I misunderstood, let me know and I will try again.  John

What I am confused is that a specific customer with a specific price (it works with RICHARDS' customer pricing),"not all of them" want a differrent trademarkcasing also several other customers need their own trademark (differrent from default trademark)
can we make this casingname automaticly shownup after clicking the productname field as the price with vba
thank you very much